From 2008 BOL on BCP & Sparse columns:

Bulk Copy (BCP) Support for Sparse Columns

There are no changes to the BCP API in either ODBC or OLE DB for the sparse...

Still waiting for an answer to my question.

Yes. And you should never post actual passwords for admin accounts on...

Use NULL as your flag value, like this:

DECLARE @Orders TABLE

(

OrderDescription varchar(6),

...

This will work better if you ask us a question.

Can you attach the file?

Please see this article on how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Tell us what you are doing in each case to check the version.

Jeff Moden (9/17/2008)

---

And, in this case, if you create the proc and then write an exec to call it, and just do a Display Estimated Execution plan, it's almost as...

Glad we could help.

Numbers that are off by "1" for a single digit only from the "correct" number 1203:

Glad I could help...

Thanks for the feedback, Ted.

Exactly.

Not sure, but they probably need the SQL Native Client driver.