27 February, 2011

Get All Friday Date of a Year in MS SQL

--Exec [dbo].getFriday '2011'
Create procedure [dbo].getFriday(@pYear nvarchar(50))
AS
BEGIN
DECLARE @FirstDay datetime
declare @intFlag int
set @FirstDay='01 Jan '+@pYear
set @intFlag=2
if datepart(dw,@FirstDay)=6 --For friday=6,Sunday=1....
print 'Friday: '+@FirstDay
WHILE (@intFlag<=365)
BEGIN
set @FirstDay=DATEADD(dd,1,@FirstDay)
set @intFlag = @intFlag + 1
if datepart(dw,@FirstDay)=6
print 'Friday: '+@FirstDay
END
END

No comments:

Post a Comment