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

Content with tags T-SQL, function Rss

   Items 1 to 7 of 7   
 

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,125 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,578 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 2011/04/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,406 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,370 reads

4-4-5 Calendar Functions, Part 2

Part 2 showing how to get the Period in a 4-4-5 Calendar  Read more...
By Cliff Corder 2010/01/11 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 8,613 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,370 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 2011/04/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,406 reads
   Items 1 to 7 of 7   
 
Tags
4-4-5 accounting (2)    
fiscal year (2)    
udf (2)    
concatenate (1)    
datetime (1)    
geometry (1)    
gps (1)    
spherical coordinates (1)    
split (1)    
string (1)    
zip codes (1)