[عبدالله الدوسري]

   

كود :

SELECT
    [BillReport].[DayName],
    [BillReport].[DayDate],
    iif([BillReport].[TotalReceivedBills] IS NULL, 0, [BillReport].[TotalReceivedBills]) AS TotalReceivedBills,
    iif([BillReport].[TotalNunReceivedBills] IS NULL, 0, [BillReport].[TotalNunReceivedBills]) AS TotalNunReceivedBills
FROM
(
    SELECT
        (SELECT TOP 1 [Dyas] FROM [dbo].[TBL_Blies] WHERE [Date_B] = DR.Date_B) AS [DayName],
        DR.Date_B AS [DayDate],
        (SELECT SUM(T1.Totels) FROM [dbo].[TBL_Blies] AS T1 WHERE T1.Date_B = DR.Date_B AND T1.Stat_Biles = 1 ) AS [TotalReceivedBills],
        (SELECT SUM(T2.Totels) FROM [dbo].[TBL_Blies] AS T2 WHERE T2.Date_B = DR.Date_B AND T2.Stat_Biles = 0 ) AS [TotalNunReceivedBills]
    FROM (SELECT DISTINCT [Date_B] FROM [Test1].[dbo].[TBL_Blies]) AS DR
) AS BillReport
ORDER By [DayDate]

نص الإستعلام موجود في الملف النصي المرفق :

  SqlBillsReport.txt (الحجم : 801 بايت / التحميلات : 8)