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,004 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,501 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,167 reads
Blogs
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process...
Forums
Database Migration
can you please provide your feedback on following scenario. i am migrating a database...
Sampling : Select the sample records
hi, I have a data like below where i need to randomize data by...
ROUND or CONVERT the output of the POWER function
Hello smart people, I am trying to use the POWER function to return data...
Ask SSC