Success!

Note

Error

Session expiration Your session is going to expireClick here to extend

Budget:

Small project <800

Posted on

2/25/13 8:40 PM

Buyer:

jim***

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now

Description

I am looking for somebody to help me create astament where i can fold up the product names into a single row.

Something like this:
 
SELECT  opp.OPPORTUNITYID, opp.OPPORTUNITY_NAME
   (SELECT 
Substring(
(
SELECT ', ' + ps.PRODUCTSERVICEID 
                      FROM   OPPORTUNITY_PRODUCTSERVICE ps, OPPORTUNITY op
                      WHERE   ps.OPPORTUNITYID = op.OPPORTUNITYID
                      FOR XML PATH('')
)
, 3, 10000000
) AS list
     ) AS Products
 
FROM  OPPORTUNITY opp
GROUP BY opp.OPPORTUNITYID,opp.OPPORTUNITY_NAME; 
 
But I can not get it to work.
 
I want to open a relation to somebody who can help me on an hourly basis for these advanced SQL statments.
Are you available on an hourly basis via webex or gotomeeting?
-- Jim D.