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,008 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,008 reads
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,568 reads
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,201 reads
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
How do I add 0 in the beginning but the length of the value...
Comments posted to this topic are about the item GitHub Copilot - Our Best...
I hav a table that holds sports betting lines that i am using in...