Using Recursion and Date Tables to Simplify Date Logic
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
2011-12-13
10,588 reads
David Beardsley
Blogs
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Synapse Analytics Spark Example 1 - Group By
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Forums
Azure Data Factory Copy Data UpSert with Delete
Hi, I'm having some problems with several Data Factory Copy Data jobs using stored...
XML Load Error
Hello everyone, I'm attempting to connect to an xml file so I can later...
Date format - being overridden?
Hi all, Got a strange one here that I hope someone can help with....
Ask SSC