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

Scripts by Adrian Facio

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Format decimal value to fraction using a tally table.

We use a tally table to find the appropriate denominator for a given decimal part of a number.   Read more...
By Adrian Facio 2014/04/29 | Source: SQLServerCentral.com | Category: format
Rating: |  Discuss |   Briefcase | 867 reads

Trim Left Char (for single words)

Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.  Read more...
By Adrian Facio 2012/08/16 | Source: SQLServerCentral.com | Category: trim
Rating: |  Discuss |   Briefcase | 922 reads

BusinessDaysToCalendarDays (For Unusual Business Weeks)

Tells how many calendar days are needed to complete a number of bussines days starting in a defined day of the week.   Read more...
By Adrian Facio 2012/07/23 | Source: SQLServerCentral.com | Category: business days
Rating: |  Discuss |   Briefcase | 699 reads

BussinesDaysToCalendarDays

Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.  Read more...
By Adrian Facio 2012/07/20 | Source: SQLServerCentral.com | Category: business days
Rating: (not yet rated) |  Discuss |   Briefcase | 800 reads
   Items 1 to 4 of 4