SQL Clone
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. 
By Luis Cazares 2015/11/18 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 723 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,589 reads
   Items 1 to 2 of 2