Wednesday, 16 December 2015

SQL SERVER – Split Comma Separated List without Using a Function

Create table “tblTest” in sql server   This is how data looks like in the table   With the above data available, they want it split into individual values. Searching for possible solutions, here is the solution query I came up with: DECLARE @temp TABLE(               ID INT,              ...

Monday, 16 February 2015

Auto Generate Paired Number

...

Monday, 4 August 2014

Read Excel files data and insert in to SQL Table

Normal 0 false false false EN-US X-NONE X-NONE ...