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.

Whether I agree with bit-masking in SQL Server or not, I enjoyed the article. Thanks.

I'm looking for a way to check for a view or table and if it is there, do nothing, if it is not there create it. Typically there is the...

Have you actually tried that and gotten it to work?

Besides, if you're gonna take the time to define a table variable, you might just skip that step and...