05-05-20, 01:36 AM
كود :
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)
