2013-08-22
14,869 reads
CROSS JOIN
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,768 reads
TSQL that lists all numbers from 1..100
This query shows how to write a T-SQL statement that lists all numbers between 1 and 100 ordered, without use of any DATABASE table with only ONE select statement.
2012-02-20 (first published: 2011-12-31)
2,086 reads
Using CROSS JOIN queries to find records out of sequence
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
2009-01-28
4,596 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
SSIS C# Script Question
Hi everyone I am working on a SSIS package where I am automating data...
Review Early and Often
Comments posted to this topic are about the item Review Early and Often
SQL Agent jobs - script to get what jobs failed
I have been trying to find SQL that shows what SQL Agent jobs failed...
Ask SSC