... and when it comes to % of batch, it can still lie!

EDIT:

I originally (incorrectly :blush: ) suggested do something like this... but, as Peso pointed out below, it's going to throw an error if table doesn't actually exist. My appologies...

OP has "left the building"... 😛

Heh... dang... thanks Kevin! I should'a looked in BOL...

Matt Miller (2/15/2008)

---

...It's a shame it took them all of the way until 2005 to hear the clamouring out there, so that they introduced the "include column headers into the...

Thanks for...

Matt Miller (2/15/2008)

---

I suppose you're going to tell me I'm getting to be predictable now.... :hehe:

There's the obvious way, emulating a SQL-style cursor, which seems oh so very obvious. ...

Frank,

Heh... understood on things possibly changing...

It's a bit funny... for years, people jumped on me for using the occasional undocumented feature (xp_DirTree to be specific) because "Microsoft could...

TheSQLGuru (2/15/2008)

---

2) use of a table variable voids the use of parallelism which can significantly reduce performance for large dataset processing./quote]

Kevin, do you, by any chance, have a Microsoft article...

Heh... as you said... "Well!!!!"

What might be even more interesting is to find out what the CLR does "AAAAAAND" why you think you need a CLR to do...

Since you didn't say what the datatype of the CSV column is, and since you said 2005", I can only assume the "worst". This would run much faster with...

So OK let's continue. Back to lengths. I'm not so concerned about limit of 30 symbols per identifier however, I'm quite amazed by following math in SQL Server:

select len(a), len(b),...

You can also use the "3rd operand" of round which identifies whether the number should be rounded or truncated (as you've asked for)... the information for the 3rd operand is...

Heh... and I damned sure wouldn't have actually written the performance enabled code the way I did... I did that just to make cuff's match collar in the code performance...

Heh... I did look at the "Example C" code you referenced... guess that proves that even people who write the documentation can be card carrying members of the Darwin Award......