Retorna todos os dias de um determinado mês
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
declare @month int, @year int set @month = 6 set @year = 2008 SELECT CAST(CAST(@year AS VARCHAR) + '-' + '01-' + CAST(@Month AS VARCHAR) AS DATETIME) + Number FROM master..spt_values WHERE type = 'P' AND (CAST(CAST(@year AS VARCHAR) + '-' + '01-' + CAST(@Month AS VARCHAR) AS DATETIME) + Number ) < DATEADD(mm,1,CAST(CAST(@year AS VARCHAR) + '-' + '01-' + CAST(@Month AS VARCHAR) AS DATETIME) ) |