Browse by Tags

All Tags » normalise (RSS)

CSV to Multiple Columns

If the table is denormalised and has Comma Seperate Values in a column, this code will copy it to Multiple columns of a Normalised table declare @DeNormalisedTable table ( data varchar ( 8000 )) insert into @DeNormalisedTable select '1,Davolio,Nancy'...
Posted by Madhivanan | 2 comment(s)
Filed under: , ,