Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Chuck Hoffman

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

TSQL TestBits function for rapidly testing multiple switch settings

Are multiple binary switches becoming hard to manage? The TestBits function can help with that.  Read more...
By Chuck Hoffman 2012/04/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,024 reads

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.  Read more...
By Chuck Hoffman 2012/04/26 | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 14,957 reads

Selecting from hierarchies like Managers and Employees

Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.  Read more...
By Chuck Hoffman 2012/05/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,634 reads
   Items 1 to 3 of 3