Sunday, January 25, 2015

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


DECLARE @dateFlag date
SET @dateFlag = getdate()-180

WHILE (@dateFlag <=getdate())
BEGIN
SELECT @dateFlag
SET @dateFlag = @dateFlag + '1'
END


No comments:

Post a Comment