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

Scripts by Megan Beebe

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Get Business Time

Compare two timestamps and return the difference in either days, hours, minutes or seconds using the 5 workday, 8 hour rule.  Read more...
By Megan Beebe 2008/07/21 | Source: SQLServerCentral.com | Category: datediff
Rating: |  Discuss |   Briefcase | 762 reads

Count Business Days

Using a few constants and a few numeric properties found in two days, calculate the number of workdays between two days.  Read more...
By Megan Beebe 2008/07/18 | Source: SQLServerCentral.com | Category: datediff
Rating: |  Discuss |   Briefcase | 1,517 reads

Insert multiple rows into variable

This is a very useful trick for working with variables.  Read more...
By Megan Beebe 2012/05/17 | Source: SQLServerCentral.com | Category: variables
Rating: |  Discuss |   Briefcase | 3,332 reads
   Items 1 to 3 of 3