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)
26,210 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
9,652 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,216 reads
Blogs
PowerShell (and T-SQL) and Elastic Jobs
I’ve covered how to create Elastic Jobs in the portal (this one is important...
A New Word: Redesis
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
Friday Flyway Tips: Autopilot in 10 minutes
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
Forums
No End to Programmers
Comments posted to this topic are about the item No End to Programmers
Solution to a problem without using a CURSOR
Hi there to all SQL gurus So, here is the scenario. I have a...
Error when running sql server backup routine job
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
Question of the Day
Counting Bits II
What is the result of this query in SQL Server 2022+?
select bit_count('7') See possible answers