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

Content with tag Table Valued Function Rss

   Items 1 to 7 of 7   
 

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2015/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,038 reads

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.  Read more...
By Robin Langell 2014/09/03 | Source: SQLServerCentral.com | Category: easter sunday
Rating: |  Discuss |   Briefcase | 647 reads

Get Modified Objects As on Date

This table Valued Function return the Modified Objects (SP /Views) For the Date specified.  Read more...
By abmore 2011/10/07 | Source: SQLServerCentral.com | Category: table valued function
Rating: |  Discuss |   Briefcase | 1,350 reads

Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...  Read more...
By Lynn Pettis 2009/05/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,537 reads

UDF to return a multi column table of values from an input string

This UDF returns a multi column table of values from an input string of comma separated values  Read more...
By Andy S 2008/06/11 | Source: SQLServerCentral.com | Category: user defined function (udf)
Rating: |  Discuss |   Briefcase | 1,303 reads

Get Modified Objects As on Date

This table Valued Function return the Modified Objects (SP /Views) For the Date specified.  Read more...
By abmore 2011/10/07 | Source: SQLServerCentral.com | Category: table valued function
Rating: |  Discuss |   Briefcase | 1,350 reads

Table-valued function FTParsedINT

This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.  Read more...
By Mark Drobnis 2007/11/22 | Category: table valued function
Rating: |  Discuss |   Briefcase | 860 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (3)    
user defined function (udf) (2)    
administration (1)    
blogs (1)    
date manipulation (1)    
easter sunday (1)    
inline table valued function (1)    
itvf (1)    
patindex (1)    
regex (1)    
set-based (1)    
strings (1)