How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
2013-12-25 (first published: 2010-10-11)
8,676 reads
CTE
2010-03-03
4,188 reads
Convert String to a Table using CTE
Explains how to convert a list of Ids passed as string and convert it to a table
2009-12-14
13,537 reads
Blogs
Scary Scalar Functions - Part Two: Performance
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
Goal Progress for June 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Using Sessionize for Your User Group – Part 2
Now that your CFS has been setup it’s time to get the word out...
Forums
Put result of one query into another
Hi all! I have to do this 177 times more, and it must be...
Add a column with default value
Hi guys I have a query with a SELECT statement, that joins 2 other...
Help with Pivoting Table
Hi all, Can someone please help Pivot a table. The table currently looks like...
Ask SSC