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,995 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,378 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,083 reads
Blogs
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
You don’t need a blockchain
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
Daily Coping 27 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
C?p nh?p d? li?u dánh giá sàn icmarkets chu?n xác nh?t
Ic markets là sàn th? nào dây ? gi?y phép và các th? t?c...
Mumbai to Lakshadweep cruise
- Explore beautiful cruise destinations like Goa, Lakshadweep, Colombo, Maldives & many more by...
Ask SSC