2
votes
0answers
545 views

how to split the column with cross apply in sql server 2008 [closed]

I have a table like this VM1 SPLA - WINSVRSTD #P19-9999 QTY 1 VM2 SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA #P39- 9 9 99 QTY 3:SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA ...