Here is a sample to get the number of days in a month, for a given month and a year declare @zMonth as varchar (2), @zYear as varchar (4) ...