Heh... That would be true for outputs... imported files are a whole (or is it "hole"?) 'nuther story....

TheSQLGuru (11/29/2007)

---

Kevin Boles. Glad to meet you. You must be Jeff Moden, right?? 😉

BTW, do you LIVE on this forum or something?? I needed the link...

The problem is that the header row does not have the same number of delimiters as the rest of the file. Unfortunately, Bulk Insert counts delimiters as well as...

Heh... "CharString"? Better have a look at BOL yourself 😀

It is possible to populate a variable in such a way, but you'll need to use sp_ExecuteSQL... please see Books Online for the example of how.

The reason why it didn't...

Since sp_SpaceUsed returns 2 result sets, I'm thinking that's just not going to do everything you'd expect. Right idea, though. 🙂

I'm not sure if this is the same interpretation that Chris offered, but, #1... I don't ever load data from a text file directly into the target table. I...

Agreed... a 2 operand COALESCE is identical to ISNULL and has the same "problem" with finding nulls, in this case.

To expound upon the point that Matt makes, consider...

DBCC UPDATEUSAGE has nothing to do with statistics.

Oh, one more thing. Does everyone else have the problem with copying out the 'code block' lines and pasting them in QA and they come out all on one line,...

Now, we're talking! I look forward to the...

Heh... I'm a bit more like Clive... write my own tools whenever possible... that way, they do exactly what I want and I can change them if I need to.

SQLServerCentral.com 😉

Heh... sorry Lynn... you're right...

Thanks, Ed... and I fully understand about the "company name" thing... I gave almost the same answer on a similar request for code. Nice to see some "ethics".