i need to seperate out the number and description from a field (not created by me!)Table in MSSQL 2005
example of existing Table
Ref id Desc
1234 1 ABCD,ABCD,ABCD
1234 2 CDFD,CDFD
i want new table
REF id qty Desc
1234 1 3 ABCD
1235 2 2 CFFD
Thanks for amy help
example of existing Table
Ref id Desc
1234 1 ABCD,ABCD,ABCD
1234 2 CDFD,CDFD
i want new table
REF id qty Desc
1234 1 3 ABCD
1235 2 2 CFFD
Thanks for amy help