Months between two dates

by 
DECLARE @StartDate  DATETIME,
        @EndDate    DATETIME;

SELECT   @StartDate="20110501"        
        ,@EndDate="20110801";


SELECT  DATENAME(MONTH, DATEADD(MONTH, x.number, @StartDate)) AS MonthName
FROM    master.dbo.spt_values x
WHERE   x.type="P"        
AND     x.number <= DATEDIFF(MONTH, @StartDate, @EndDate);

Results:

MonthName
------------------------------
May
June
July
August

(4 row(s) affected)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Making a dynamic pivot table but without using the fiddle
  3. Get top 1 row of each group
  4. How to cast the DateTime to Time
  5. Row Offset in SQL Server
  6. SQL Server recursive self join
  7. Why is SQL Server losing a millisecond?
  8. Generate a resultset of incrementing dates in TSQL
  9. Find a string by searching all tables in SQL Server
  10. How to get script of SQL Server data? [duplicate]
  11. How do I split a delimited string so I can access individual items?
  12. Common Table Expression, why semicolon?
  13. T-SQL split string based on delimiter
  14. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  15. Why use Select Top 100 Percent?
  16. How do I find duplicates across multiple columns?
  17. Add unique constraint to combination of two columns
  18. What does a transaction around a single statement do?
  19. How to store historical records in a history table in SQL Server
  20. separate comma separated values and store in table in sql server
  21. How to export image field to file?
  22. Move SQL data from one table to another
  23. Stored procedure that exports data into csv files only exports to one file
  24. Get Start and End Date from Week Number SQL Server
  25. Get the last day of the month in SQL
  26. INSERT VALUES WHERE NOT EXISTS
  27. Nested select statement in SQL Server
  28. SQL take just the numeric values from a varchar
  29. Cumulative Total in MS Sql server [duplicate]
  30. Export table data from one SQL Server to another

Leave a Comment