Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM dbo.Split
- (',', (SELECT myColumn FROM Stuff WHERE id = 22268))
- WHERE ISNULL(s,'') <> ''
- pn s
- ----------- -----------
- 1 22351
- 2 22354
- 3 22356
- 4 22357
- 5 22360
- SELECT *
- FROM dbo.Split
- (',', (SELECT myColumn FROM Stuff))
- WHERE ISNULL(s,'') <> ''
- SELECT * FROM dbo.Split_temp(',', myColumn), Stuff
- id pn s
- ----------- ----------- -----------
- 22268 1 22351
- 22268 2 22354
- 22268 3 22356
- 22268 4 22357
- 22268 5 22360
- 24104 1 22353
- 24104 2 22355
- 24104 3 22356
- 24104 4 22358
- 24104 5 22360
- 24104 6 22362
- 24104 7 22364
- .
- .
- .
- id myColumn
- ----------- -------------------------------------------
- 22268 22351,22354,22356,22357,22360,
- 24104 22353,22355,22356,22358,22360,22362,22364,
- SELECT Stuff.id
- ,Results.pn
- ,Results.s
- FROM stackoverflow_454945 AS Stuff
- OUTER APPLY dbo.Split(',', Stuff.myColumn) AS Results
- WHERE ISNULL(Results.s,'') <> ''
- declare @split varchar(max)
- set @split = ''
- select @split = @split + Coalesce(myColumn + ',' , ' ')
- from Stuff
- WHERE id = 22268
- select * from dbo.Split(',', @Left(@split,len(@split) -1))
Add Comment
Please, Sign In to add comment