Grant Fritchey (3/5/2008)

---

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could...

Pretty good article, Paul... straight and to the point.

admin (3/5/2008)

---

Definitely an ingenious solution; however, it can quickly become a poor approach when having to deal with larger import file -think telephone call records for instance.

I've found that the...

For your definition of "ragged right", is...

paul.ibison (3/5/2008)

---

True - the title is a little misleading. The problem is that there isn't a 'correct' term for such files and this is the nearest commonly understood one. Anyway,...

Sure... dunno how many of these you have to do, but the following is about twice as fast because there's only 1 Reverse and RIGHT is faster than SUBSTRING.

[font="Courier New"]DECLARE&nbsp@FileName&nbspVARCHAR(256)

&nbsp&nbsp&nbsp&nbspSET&nbsp@FileName&nbsp=&nbsp'D:\File\Data\test\Test.xls'

&nbspSELECT&nbspRIGHT(@FileName,CHARINDEX('\',REVERSE(@FileName))-[/font]1)

Of...

Wait a minute... are you saying that a system already exists and already has customers...

Ya know... I busted a bit of a hump for ya here... and no one on the other forum came close... the least you could do, MH, is let me...

Steady... don't let this shake you, Loner...

And 5000 hits per second does not equal .02 seconds... on a single cpu system, that would be .0002 seconds. Multiply that times...

The length of the number of characters plus 6 or 8 bytes worth of length info.

Question is, why are you using VARCHAR(MAX) if it'll never get bigger than a thousand...

Heh... And the GUI rules... it may take longer and it may run slower, but the GUI rules.

Bill Gates was right 15 years ago... someday there won't be any...

What do you want it to do?

Based on that link, I'm thinking this is someone's homework... wait a minute... I've got a porkchop around here somewhere... maybe even a Yak Burger, huh, Peter?

Only if you promise to avoid cursors and while loops like they were going to kill you... because they'll certainly kill the performance of your code. There's almost always...

I sure do... read the URL in my signature. People will come screaming out of the woodwork to answer your question almost before you can ask it if you...