Sunday, January 25, 2015

how to get working date loop? I need each days time for last 6 months any suggestion?

Try:



WITH
t4 AS (SELECT n FROM (VALUES(0),(0),(0),(0)) t(n))
,t256 AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS num FROM t4 AS a CROSS JOIN t4 AS b CROSS JOIN t4 AS c CROSS JOIN t4 AS d)
SELECT *
FROM [dbo].[FactInternetSales]
WHERE OrderDate IN (
SELECT DATEADD(day,-num+1,CAST(GETDATE() AS date))
FROM t256
WHERE num <= 180);





Dan Guzman, SQL Server MVP, http://www.dbdelta.com


No comments:

Post a Comment