Viewing 2 posts - 1 through 3 (of 3 total)
I hope it helps you to find your happy place. Good luck!
September 16, 2009 at 9:37 am
#1054550
We've had success with this using cross apply. Please see the following pseudocode:
SELECT
firstname,
lastname,
personpk,
ColorsList = LEFT(ColorList.list, LEN(ColorList.list)-1)
from persons
...
September 16, 2009 at 8:40 am
#1054498