Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mjmdgov
-
Need help creating SQL query to roll up dates which include date gaps
Hi folks, I've been tasked with creating a query that consolidates dates that are consecutive and contains non-consecutive dates. For example: 1000 04-01-2001 03-31-2002 1000 04-01-2002 03-31-2003 1000 04-01-2002 08-17-2002 1000 01-01-2008 01-03-2008 1000 01-01-2008 12-31-2008 needs to look...- mjmdgov
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
