Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
25,965 reads
Chuck Hoffman
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
8,844 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,060 reads
Blogs
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology...
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Forums
SQL Query Assistance Required
Hi. I am wanting to know if there is a way to make this...
Microsoft Exam 98-364 (Database Fundamentals)
Has anybody here taken the 98-364 exam?
Stairway to Database Containers Level 3: Building Custom Container Images by Hand
Comments posted to this topic are about the item Stairway to Database Containers Level...
Ask SSC