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

Content with tag Scalar-valued Functions Rss

   Items 1 to 8 of 8   
 

How to calculate the check digit for a UCC/EAN code

Function that implements the algorithm for calculating the check digit for a UCC/EAN code  Read more...
By Sergio Govoni 2012/08/29 | Source: SQLServerCentral.com | Category: barcode
Rating: |  Discuss |   Briefcase | 1,774 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,548 reads

SQL Server Functions: The Basics

SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.  Read more...
By Additional Articles 2011/11/24 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,682 reads

Calculating the Number of Business Hours Passed Since a Point of Time

A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.  Read more...
Rating: |  Discuss |   Briefcase | 2,659 reads

random integer number scalar function

this produces a random integer between a certain range  Read more...
By Chris Morton 2008/12/12 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 810 reads

How to calculate the check digit for a UCC/EAN code

Function that implements the algorithm for calculating the check digit for a UCC/EAN code  Read more...
By Sergio Govoni 2012/08/29 | Source: SQLServerCentral.com | Category: barcode
Rating: |  Discuss |   Briefcase | 1,774 reads

Calculating the Number of Business Hours Passed Since a Point of Time

A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.  Read more...
Rating: |  Discuss |   Briefcase | 2,659 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,548 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (3)    
datetime manipulation (2)    
barcode (1)    
rand() (1)    
random numbers (1)    
table functions (1)    
ucc/ean (1)    
user defined function (udf) (1)