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

Content with tag function Rss

   Items 1 to 20 of 45    Older >>
 

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 360 reads

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,993 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 | 405 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 | 558 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 | 937 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 | 352 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,030 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,030 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 | 1,013 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,705 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 | 917 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 | 389 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,705 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,134 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,533 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,773 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,467 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,792 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,533 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 | 833 reads
   Items 1 to 20 of 45    Older >>
 
Tags
t-sql (6)    
datetime (4)    
convert (3)    
date (3)    
string (3)    
4-4-5 accounting (2)    
administration (2)    
age (2)    
calculation (2)    
card (2)    
cast (2)    
column (2)    
concatenate (2)    
dax (2)    
delimited (2)    
fiscal year (2)    
formula (2)    
measure (2)    
miscellaneous (2)    
power bi (2)    
slicer (2)    
sql (2)    
stored procedure (2)    
string manipulation (2)    
time (2)    
udf (2)    
visualization (2)    
active directory (1)    
ad (1)    
adsi (1)    
age calculation (1)    
archive file (1)    
archiving data (1)    
ascii (1)    
c# (1)    
calculated (1)    
code (1)    
comment (1)    
concat() (1)    
concatenatex (1)    
concatenation (1)    
count() (1)    
counta() (1)    
countax() (1)    
data management views (1)    
datepart (1)    
daylight (1)    
dba (1)    
decode (1)    
dependencies (1)    
dependency (1)    
desktop (1)    
dmv (1)    
easter sunday (1)    
expressions (1)    
filename (1)    
filter (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
formatting (1)    
functions (1)    
fuzzy (1)    
geometry (1)    
gps (1)    
hash (1)    
hashing (1)    
html (1)    
len() (1)    
matrix (1)    
neural (1)    
number to words (1)    
numbers (1)    
numbers only (1)    
power bi desktop (1)    
report (1)    
reporting services (ssrs) (1)    
savings (1)    
scalar function (1)    
script (1)    
scripts (1)    
search (1)    
spell (1)    
spherical coordinates (1)    
split (1)    
splitter (1)    
sqlclr (1)    
stored procedures (1)    
substring (1)    
sum (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)    
zip codes (1)