OK, try this:

Create proc p_GetMonthDays (@year varchar(4),@month varchar(2))
as
declare @date char(10)
set @date = @month + '-01-' + @year
select datepart(day,dateadd(day,-1,(dateadd(month, 1, @date)))) 'Days In
Month'

You need to pass the year (2008) and month number (2),

exec p_GetMonthDays 2008,2

returns this:

Days In Month
-------------
29

(1 row(s) affected)

Of course, this could be 'neatened' up a lot (enter month name, convert to
month number, remove column name, No error checking, etc.), but it's a
start.

It starts with the first day of the month you enter, adds one month, goes
back one day, and gets that day number.

Mark Siltala



[quoted text, click to view]