Ask Paula!

...bringing you notes from the field...

  Home  |   Contact  |   Syndication    |   Login
  147 Posts | 5 Stories | 133 Comments | 0 Trackbacks

News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud


Article Categories

Archives

Post Categories

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

March 2017 Entries

-- converting column with commas to multiple columns --declare @col1 varchar(500)set @col1 = 'I,Hate,Broccoli'DECLARE @Tmp TABLE ( Id int, Element VARCHAR(20)) INSERT @Tmp SELECT 1,@col1 SELECT Id, PARSENAME(REPLACE(Element,'... Name, PARSENAME(REPLACE(Element,'... Surname FROM @Tmp-- converting column with commas to multiple rows --declare @col1 varchar(500)set @col1 = 'I,am,really,a,smart person, one of the smartest'DECLARE @Tmp TABLE ( Id int, Element VARCHAR(200)) INSERT @Tmp SELECT ......