You've exemplified exactly what I was talking about, Gints... doesn't really matter what people think of one or the other, they are very different and anyone who thinks that the...

The LEN failure is because you are missing a couple of right parenthesis in the code line.

Also, is there only 1 name per row or do they look like something...

Heh... I knew it would be YOU, Matt... after all the testing you did for/with me on the "other" CLR's, I should have just asked "Hey Matt... you wanna try...

Hi Alicia...

Since you're trying to "export" the file from an .xls file to a table, you'll need to follow a couple of "rules" about the format of the .xls file....

Christopher Ford (2/15/2008)

---

So I says to myself, bah, table variable...you can do it without a table variable!

... for an interesting exercise, please run this...or better yet, don't run this unless...

Thanks for joining the thread, Frank... just curious... you posted the following... and said it takes 2 seconds on your machine...

Out of curiousity, if we were to grab the current...

I get what you want to do... but, I'm with John... I need more info, please...

Also, what do you mean by "unitil No ID's are left"? Are you saying...

--===== Create a test table with data

-- THIS IS NOT PART OF THE SOLUTION

DECLARE @YourTable TABLE (DocNo VARCHAR(20),LiNum INT)

INSERT INTO @YourTable (DocNo,LiNum)

SELECT 'ZC12345',1...

So, maybe write some code that writes code for you?

Also, you can set the results in the text mode to use the TAB character to separate columns to make the...

DOH! (making thumbsucking noises and triddling hair)... sometimes I just get balled up on things. Of course, Greg!... Nice simple solution like that is the way to go....

Matt S... yeaup... a bit "contrived" as you say... the example is meant to mimic the real world where people forget what datatype they're using to do calculations and the...

GSquared (2/15/2008)

---

Even in that case, using float instead of decimal resulted in a measureable speed increase. (I have to calculate distances between sets of up to 4-million records and...

Caught me? Heh... I jumped right out in front of ya 😀

What you say is similar to what I used to say and think.

ALZDBA (2/15/2008)

---

Well it certainly started with a great article, handling a fairly common issue 😎

And it resulted in a solution that worked a lightning speed and performed

the actual update in...

Ross McMicken (2/15/2008)

---

The biggest issue we've had with using money datatypes is that reports in Crystal, and other tools, put a $ sign on each foeld by default. Given tha...