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,035 reads
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,035 reads
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,607 reads
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,211 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers