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,084 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,548 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,400 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,344 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,582 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,344 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,400 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)