SELECT

'"'+Field1+'"' + ',' +

'"'+Field2+'"' + ',' +

'"'+Field3+'"' + ',' +

...

Fieldn AS TheOutput

FROM table

Wrap them in double quotes in case anything has a comma in it.

Anyone should know that if you don't test your backup and recovery plans often you should plan to fail. It is unacceptable to find out you backups were not running...

Eric M Russell (3/23/2012)

---

Truth be told, some IT guys are probably intimidated by the prospect of a new hire to the department who will be doing the same or similar...

I have to add my own gripe here about this typo. I took "SQLAgentAgent" to be a trick and not a typo so I didn't pick it.

I completely agree.

Easy killer.

Know it all developers, flawed test, etc. Perhaps it is hard to win. A recommendation from a person who already works at the company is a great thing as mentioned...

It should also be noted that this can cut both ways. Many times when a developer is asking questions of a DBA applicant they will not ask Administration based questions...

Resume reads:

"I am a master of Sequel Server"

Yeah uh okay.

Tabs

Thanks Gila' for the explanation. I'm one of the dummies who thought it was a page lock.

I ended up having to unregister and reregister all DLL files in that directory.

If anyone needs it here is a sample of how to use the where clause. You simply use double quotes.

SELECT * FROM OPENQUERY(UNDERWRITING,'SELECT * FROM RS_INV03 where memb_num="01804-00"')

Thanks you, thank you, thank you! I searched the MS site but this doc never came up. The key was this:

SQLCommand="SELECT * FROM OPENQUERY(VFP,'SELECT * FROM CUSTOMER')"

I used:

SELECT *...