2012-05-07
2,558 reads
T-SQL
2012-05-03
2,872 reads
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,795 reads
2012-04-26
3,022 reads
2012-04-24
2,695 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2012-10-05 (first published: 2012-04-23)
1,507 reads
2012-05-09 (first published: 2012-04-19)
1,371 reads
2012-04-17
2,650 reads
2012-04-13
3,258 reads
TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,243 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers