Get list of all Dates in SQL without SP

Posted by Ravianand under Sql Server on 11/1/2012 | Points: 10 | Views : 880 | Status : [Member] | Replies : 2
Get list of all Dates in SQL without SP.

input : Month & year
Ex: 01 and 2012
Solution as:

01/01/2012
02/01/2012
03/01/2012
.......
31/01/2012

Regards,
Ravi



Responses

Posted by: Pandians on: 11/1/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
Please use recursive CTE

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Ravianand, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajayk3 on: 11/15/2012 [Member] Starter | Points: 25

Up
0
Down
DO SOMETHING LIKE THIS

DECLARE @STR varchar(1000)=''
DECLARE @R int=1
while @R<=31
BEGIN
SET @STR= @STR + CAST(@R as varchar) + '/01/2012' + CHAR(13)
SET @R=@R + 1
END

print @STR

Ravianand, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response