I've just read through this thread, hoping, hoping, that someone had found a 'great' (or workable) solution. Alas, it isn't so. I'll add, though, that in the VS6 days source...

Thanks for the script: I'm lucky that these helpful tools seem to come along at exactly the right time for me.

Cheers from Denver,

Mark Starr

Yeah, that's...

Thanks for the quick and simple overview of how to use BCP with xp_cmdshell from within an SP.

Question: Are there any options to delimit text values? I'd like to...

Joe Celko (1/7/2009)

---

"A problem well stated is a problem half solved." -- Charles F. Kettering

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative...

You've probably already overcome this, but...

Since the value 'loan' is actually the name od a column, you'll need to build the name into a string to execute, vis:

DECLARE VarianceCursor Cursor...

Hi LOS,

We, too, use CF (7.0.1)

CF *does* use DNS to connect to databases by server nane *or* by IP, but unfortunately it stores the info in an XML file...

Look up the OUTPUT clause in B.O.L. - that should work for you..

Mark Starr