March 12, 2004 at 1:47 pm
I have a table with IDs as PK and attributes as string(about4k) with data delimited by vertical bar in attributes column. Now I need to split attributes to separate columns using this delimiter. Appreciate any help. |
March 12, 2004 at 1:51 pm
look up charindex, patindex in BOL.
March 12, 2004 at 1:56 pm
Thanks for the fast reply. I need to do it dynamically, as soon as attributes are changed.
March 12, 2004 at 2:39 pm
An insert, update trigger using charindex or patindex will work.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 12, 2004 at 2:48 pm
Yes, I agree. I need a trigger with UDF that loops thru the attributes and returns a table with lot of columns with a separate attribute in each column for specific ID. Can someone send me a sample script? |
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply