我正在尝试找到一种方法来填充矩阵中没有数据的日期。
我现在拥有的如下
但我也想显示之间的所有日期。
我尝试了几种不同的 iif 语句,但要么出现错误,要么没有变化。
SELECT ee.No, TTMain.CustFn, me.Date_Opened AS [I Open], me.Date_Closed AS [I Sch Close], TTMain.ttfn00,
ee.Cls_Date AS [Actual Close Date], ee.Open_Date, TTMain.Project
FROM GreatAmerican_Data.dbo.Marketing_Escrow AS me INNER JOIN
GreatAmerican_Data.dbo.Escmst_Escrow AS ee ON me.File_Number = ee.No INNER JOIN
ttMain AS TTMain ON ee.No = TTMain.ZeroZerottfn
WHERE (ee.Branch = '018') AND (me.Date_Opened Between '2/1/16' AND GETDATE()) AND (ee.Status_Date IS NULL)
ORDER BY [I Sch Close]
返回的数据中供应商名称和帐号被涂黑 https://i.stack.imgur.com/99wpF.jpg
- 声明包含月份完整日期的月份表
例子:
declare @tbMonth as Table (DayOfMonth nvarchar (10))
insert into @tbMonth ('01 Feb')
insert into @tbMonth ('02 Feb')
insert into @tbMonth ('03 Feb')
insert into @tbMonth ('04 Feb')
... 等等
- union
@tbMonth
与您的输出表,并分组[DayOfMonth]
,
Sum([您所需的列])
- Done.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)