Jeff,

That's exactly what I'm up against.  I have to do everything in t-sql to create a .csv that's formatted properly.   Oldhand's solution is what I needed. I just concatonated a '$'...

Thanks Oldhand that's perfect!

Jeff

What language are you using for yor web development. I do this all the time with php/ado but like others have said it's a pretty broad subject.

Thanks Bert that was exactly how I ended up.

Thanks everyone else for the replies. After the first reply as soon I I saw the single 'INTO' duhhh

Thanks you're right I just wrote a query to put the table in the correct normalized form......

Thanks Guys. Andy, doesn't my SET CONCAT_NULL_YIELDS_NULL OFF do the same as you recommentd for null first names?  Is it better not to use a global setting like that?

Thanks, Jeff

Thanks Govinn that was exactly what I was looking for. I didn't think of the doing it that way but it's perfect.

Jeff

I always look to BOL first but can't find what I need. I guess what I really want is to know where I can find a list of system cursors...

Thanks much guys that did it!

Thanks to all replies, the select case is what I needed.

First make sure that you can log on the the computer with the same account that the SQL service uses to log on as a service. You also need a...

Thanks for all the help guys. This is a real pain in the butt to set up. It was all in the setup nothing wrong with the code. It must...

Thanks alot for the temp table suggestion I will definatley do that.

As far as the startmail parameters that was a omission on my part. The code I'm using has...

Thanks alot guys. Everything worked great. Scott thanks for the addition I ran into the multi-row probkem at first. Once again this Forum has made my life easier and saved...

Crap. Thanks I got it. Thanks for the direction on the job log details.

I'm trying to do a differential backup of dbs listed in sysdatabases right after I do...