View Single Post
 
Old April 21st, 2009, 11:36 AM
lryckman lryckman is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Connersville, Indiana, USA.
Posts: 126
Thanks: 5
Thanked 0 Times in 0 Posts
Default

I have tried all three...I get the same error on each of them. Then I tried the following:
Code:
SELECT DISTINCT s1.CCNNumber, STUFF
                          ((SELECT     ',' + s2.PartNumber
                              FROM         dbo.view_tbl2009_PartNumbers AS s2
                              WHERE     s2.CCNNumber = s1.CCNNumber FOR XML PATH('')), 1, 1, '') AS PartNumbers
FROM         dbo.view_tbl2009_PartNumbers AS s1
This gave me an error:
"Error in WHERE clause near '('.
Unable to parse query text."
__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!