The person ID are all null when they shouldn't be. RETURNS TABLE (listpos int IDENTITY(1, 1) NOT NULL, Here is my codeĬROSS APPLY iter_charlist_to_tbl(d.treatment_areas, ' ') AS t 100 Breast Sarcomaīest Wishes, Arbi - MCC 2011 Please vote if you find this posting was helpful or Mark it as answered.Īctually, I have use that page's example and parsed out comma delimited list. Outer Apply (Select * From dbo.splitString(Replace(MainQry.ColDesc, ' ', ','), ',')) As Split Insert Into 100, 'Breast Sarcoma Head and Neck Prostate Malignancies' Union All Insert = + Table (ColInt TinyInt, ColDesc Varchar(200)) I would need to do this to all rows of that table's column. I don't get how your example is just showing separating one line of I would then use this temp table to merge this part of the data to my table. i want to extract them out toĪ temp table so each double space entry is on its own row with correspoinding personId as the key. I'm trying to prepare those columns where they have mulitiple entries in one cell separate by double spaces. I am preparing this table to be imported or merged. ![]() ![]() The other one I have no idea what it's doing but nothing seems to be broken up. One breaks up each liter with single or double space. ![]() I have found a couple of Split functions but they don't work.
0 Comments
Leave a Reply. |