2009-05-25
1,083 reads
Swap data
RE: First Sunday and Last Sunday in a Month
This will give the first Sunday of the given month of the given year. For the last Sunday do something similar. DECLARE @month TINYINT , @year SMALLINT , @date DATETIME SELECT @month = 8 , @year = 2003 SET @date = CAST( CAST( @month AS VARCHAR ) + '/01/' + CAST( @year AS VARCHAR ) […]
2003-06-11
1 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers