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

Guest Columnist: Patrick Cahill

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2013/11/12 | Source: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 11,492 reads

Returning 0's in a SUM (SQL Spackle)

Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.  Read more...
By Patrick Cahill 2011/06/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,756 reads

Execute As

Learn how you can use Execute As in a stored procedure to control permissions. This article includes an example that limits access to encryption routines for users.  Read more...
By Patrick Cahill 2013/10/11 (first published: 2011/02/02) | Source: SQLServerCentral.com | Category: execute as
Rating: |  Discuss |   Briefcase | 16,163 reads
   Items 1 to 3 of 3