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,967 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
8,901 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,064 reads
Blogs
Event Notifications Example
By SQLPals
Event notifications are kinda like a trigger in the sense that they respond to...
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...
Batch Scripting SQLCMD–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Can't Get Attunity Oracle Connector to Work with SQL Server 2017 / Oracle 12c
I've tried many times to install the various versions of the Attunity Data Connector...
Using Java script to import word and pdf into SQL server
I am looking for example or use case codes in using Java script to...
Using sftp in Visual Studio for SSIS packages
Hi, I've inherited the maintenance of SSIS packages that were created by our former...
Ask SSC