SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag function Rss

   Items 1 to 20 of 44    Older >>
 

Fuzzy Search

Finally a fuzzy search that finds all sorts of misspellings and missing parts.  Read more...
By William Talada 2017/08/03 | Source: SQLServerCentral.com | Category: fuzzy
Rating: |  Discuss |   Briefcase | 1,917 reads

Find function dependencies

Produces a list of functions and the objects that use them.  Read more...
By Andy Robertson 2017/05/09 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 385 reads

Remove SQL Comments

This function takes in SQL code and returns the same SQL code but with any comments removed (i.e. "/**/", "--")  Read more...
By Jordan Ryder 2017/04/13 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 531 reads

Performaing a Right and Comprehensive Age Calculation Part 2

Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.  Read more...
By Sergiy Floka 2017/03/30 | Source: SQLServerCentral.com | Category: age calculation
Rating: |  Discuss |   Briefcase | 922 reads

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 345 reads

Tally Generator

Inline function generating the set of numbers based on submitted parameters.   Read more...
By Sergiy Floka 2017/03/08 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,017 reads

Tally Generator

Inline function generating the set of numbers based on submitted parameters.   Read more...
By Sergiy Floka 2017/03/08 | Source: SQLServerCentral.com | Category: tally
Rating: |  Discuss |   Briefcase | 1,017 reads

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.  Read more...
By Bill Pearson 2016/09/21 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 994 reads

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes  Read more...
By Shane Clarke 2016/08/12 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,703 reads

Format Date Time Function

Function do return common datatime formats of a date. select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())   Read more...
By Kraai 2016/04/26 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 913 reads

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function   Read more...
By Kraai 2016/04/25 | Source: SQLServerCentral.com | Category: easter sunday
Rating: (not yet rated) |  Discuss |   Briefcase | 386 reads

Function to calculate and return age in text to closest minute between

Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes  Read more...
By Shane Clarke 2016/08/12 | Source: SQLServerCentral.com | Category: age
Rating: |  Discuss |   Briefcase | 1,703 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,131 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2015/04/10 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,532 reads

Calculate Distance in Miles from Latitude and Longitude

A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.  Read more...
By RBarry Young 2014/09/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,772 reads

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.  Read more...
By Jeff Moden 2014/01/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,458 reads

Split and concatenate function

Function for splitting the values in string, applying logic and concatenating back to string.  Read more...
Rating: |  Discuss |   Briefcase | 1,791 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2015/04/10 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,532 reads

FileNameSplitter

Function to split a full file name into drive, path, file name, and extension.  Read more...
By William Talada 2013/07/03 | Source: SQLServerCentral.com | Category: filename
Rating: |  Discuss |   Briefcase | 831 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,131 reads
   Items 1 to 20 of 44    Older >>
 
Tags
t-sql (6)    
datetime (4)    
convert (3)    
date (3)    
4-4-5 accounting (2)    
administration (2)    
age (2)    
cast (2)    
concatenate (2)    
fiscal year (2)    
miscellaneous (2)    
sql (2)    
stored procedure (2)    
string (2)    
string manipulation (2)    
time (2)    
udf (2)    
active directory (1)    
ad (1)    
adsi (1)    
age calculation (1)    
archive file (1)    
archiving data (1)    
ascii (1)    
c# (1)    
calculated (1)    
calculation (1)    
card (1)    
code (1)    
column (1)    
comment (1)    
concat() (1)    
concatenatex (1)    
concatenation (1)    
data management views (1)    
datepart (1)    
dax (1)    
daylight (1)    
dba (1)    
decode (1)    
delimited (1)    
dependencies (1)    
dependency (1)    
desktop (1)    
dmv (1)    
easter sunday (1)    
expressions (1)    
filename (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
formatting (1)    
formula (1)    
functions (1)    
fuzzy (1)    
geometry (1)    
gps (1)    
hash (1)    
hashing (1)    
html (1)    
len() (1)    
measure (1)    
neural (1)    
number to words (1)    
numbers (1)    
numbers only (1)    
power bi (1)    
reporting services (ssrs) (1)    
savings (1)    
scalar function (1)    
script (1)    
scripts (1)    
search (1)    
slicer (1)    
spell (1)    
spherical coordinates (1)    
split (1)    
splitter (1)    
sqlclr (1)    
stored procedures (1)    
substring (1)    
sum (1)    
sys.dm_sql_referencing_entities (1)    
tally (1)    
text (1)    
text search (1)    
tips and tricks (1)    
useraccountcontrol (1)    
version (1)    
views (1)    
visualization (1)    
zip codes (1)