T-SQL Help please

Domo · 15 Jun 2010 at 08:31

I need to get records like this:

1234,[email protected],4444
1234,[email protected],4444
5678,[email protected],5555
5678,[email protected],5555

into a csv file like this:

1234,"mrhappy@mrmen,com;[email protected]",4444
5678,"[email protected];[email protected]",5555

Probaby something using the group by function and print?
Any suggestions are more than welcome

Domo · 15 Jun 2010 at 11:14

Hi Spunkey - there is an identifier however the number of records can vary - my example shows 2 for each 'contact record' however there can be between 1 and 100 (or more!).

Speed isnt' an issue as it's a one-off + I'm running it againt a data warehouse so won't effect prod.

Cheers.

Domo · 15 Jun 2010 at 13:06

Hi Simon - I've tried your code and get the following:

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@ret".
Msg 1087, Level 15, State 2, Line 6
Must declare the table variable "@temptable"

Domo · 15 Jun 2010 at 13:55

SimonCHere said:
Sorry I assumed you knew how to write the cursor code.
Bear with me and I'll write the rest.

I attended an advanced t-sql course a few weeks back which covered cursor and scalar functions (and how not to use then ;-)

)

Forgotten most of it as I rarely use it! Really appreciate the help though