Month: April 2012

Formatting SSN in TSQL

  The SQL below is used for taking a number and formatting it to a SSN.   select ssn,LEFT(ssn,3) + '-' + SUBSTRING(ssn,4,2) + '-' + RIGHT(ssn,4) from DbTools..Sheet1  ...

Read More

SQL Cursor and Date formatting

  I working with SQL Server a lot and have certain statements that I write and often have to search for templates for. Below is one, well actually two that I have to check for the usage when I use them. The snippet below creates...

Read More