Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- sonstiges [2026/04/15 09:04] – [SQL] lutz
+++ sonstiges [2026/04/29 09:49] (aktuell) – [SQL] lutz
@@ Zeile 52: / Zeile 52: @@
 </codeprism>
-SELECT CustomerId
+==== SQL ====
---     , Predecessor_Id
+<sxh sql>
-     , CustomerNumber
+SELECT mass.DisplayText Assignment, mc.CustomerId, mc.ShortName, COUNT(mc.CustomerId) Counter
-     , VendorNumber
+  FROM masCustomerAccumulation mca
-     , DisplayName
+       INNER JOIN masCustomer mc ON mc.CustomerId = mca.Customer_Id
-     , ShortName
+       INNER JOIN masAccumulation macc ON macc.AccumulationId = mca.Accumulation_Id
-     , ZipCode
+       INNER JOIN masAssignment mass ON mass.AssignmentId = macc.Assignment_Id
-     , City
+ WHERE mass.DisplayText IN ('Food', 'Gas')
-     , OtherVendorNumber
+ GROUP BY mass.DisplayText, mc.CustomerId, mc.ShortName
-     , OtherVendorName
+ ORDER BY Assignment, Counter DESC, ShortName
-     , CASE WHEN IsActive=1 THEN 'Active' ELSE 'Inactive' END AS IsActive
+</sxh>
-     , CASE WHEN IsReadOnly=1 THEN 'ReadOnly' ELSE 'Writable' END AS IsReadOnly
-     , CASE WHEN HasFineCutDiscount=1 THEN 'FCD' ELSE 'No FCD' END AS HasFineCutDiscount
-     , (SELECT DisplayName FROM dbo.masUser WHERE UserId = KeyAccountManager) AS KeyAccountManager
-     , (SELECT DisplayText FROM dbo.masCustomerLevel WHERE CustomerLevelId = PrimaryCustomerLevel) AS PrimaryCustomerLevel
-     , (SELECT DisplayText FROM dbo.masCustomerLevel WHERE CustomerLevelId = SecondaryCustomerLevel) AS SecondaryCustomerLevel
-  FROM dbo.masCustomer
- WHERE CustomerId IN (1, 8, 18, 99, 102, 145, 169, 227, 246, 286, 360)
 ==== Visual Basic ====