Search the Community
Showing results for tags 'tsql'.
Found 4 results
Sometimes if the database is not designed correctly you will find dates stored as text values. When trying to compare dates to text you will have problems and it's not efficient. So that's where the cast function comes in. Table: Invoice Field: InvoiceDate Data Set: 20080515 20081025 20070113 20091007 Expected Data Set: 05/15/2008 10/25/2008 01/13/2007 10/07/2009 To do this simply cast the field as a date: select cast(InvoiceDate as datetime) from Invoice
Some time ago I was reading data from a flat .txt file and inserting it into my database. My table in the database was only setup to handle 40 characters for the company or person's last name. If it was a company some would be longer than 40 and my job would fail. I chose to fix it with the substring function in MSSQL. Table: Debtor Field: RespLName My original code: select case when ltrim(rtrim(RespLName)) is null then P.LastName else ltrim(rtrim(RespLName)) end as LastName from Debtor After adding the substring function: select case when ltrim(rtrim(substring(RespLName,0,40))) is null then P.LastName else ltrim(rtrim(substring(RespLName,0,40))) end as LastName from Debtor
A while back I was trying to round some numbers to only 2 digits after the decimal in MSSQL. I figured out how to do and wanted to share. Name of Table: Invoice Field Name: BalanceDue Data Set: 100.0001 34.532 49.4732 234.567000 Expected Data Set: 100.00 34.53 49.47 234.57 To do this you can use the ROUND function within MSSQL. select round(BalanceDue,2) from Invoice