Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Luis Cazares

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Constraints renaming

Rename constraints to enforce naming conventions.  Read more...
By Luis Cazares 2015/11/18 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 696 reads

Calculating Working Hours

Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.  Read more...
By Luis Cazares 2015/10/22 | Source: SQLServerCentral.com | Category: working hours
Rating: |  Discuss |   Briefcase | 3,559 reads
   Items 1 to 2 of 2