Of course it'll slow down during the day... more locks present on the tables and the query must create an execution plan each time the app generates the code... it's...

Ya beat me to it, Ramesh!

Keep in mind that both the estimated and actual execution plans can lie like a rug... if you have any form of a loop in your code or, sometimes, a...

No, Not true. Table variables are NOT faster than TempTables. Are you saying that because you think table variables live only in memory or because you think temp...

Ray,

First, I don't see any rows in your test data that look like the following:

'-20.000 EE 01 6060 3 997' output = -20.000 EE , it should be -20.000

'-20.000 01...

If the 5 procs can be executed at the same time and you have multiple processors, I think the 5 procs running in parallel with win out over the single...

First thing I'd try is to recompile all the views involved... could be you have a bad execution plan cached up somewhere.

I've run into this problem with "views of views"...

Heh... sorry about that, but at least I got your attention....:D

I should have mentioned that I'm working on an article (may end up being two) that covers a high speed...

Merry Christmas if you're Christian, happy holiday season if you're not.

Old quote from a magnet on my fridg... "The best things in life are not things". I've got my...

Ummmm.... you didn't save a copy of the original report that worked?

Not a problem... let us know either way after you try it? Thanks...

Ray...

If, for some reason, you elect to go with the second form, you may also want to check out the following command as a possible source for your Insert...

EXECUTE...

Prakash... did YOU try it? Your...

Besides, I believe that the first script will probably blow the doors off the second script.

You bet... thank you for the feedback.