Can you post some sample data, hopefully in the form of INSERT statements, along with the CREATE statement for the table you're trying to get the data from, please?

I wouldn't say "never"... they're pretty handy when making a temp table and, since no one but the current session can use the temp table, there's no concurrency issue to...

Heh, heh.... mine are getting worse... old brain.

You hit the nail on the head about the scope thing... I was curious as to why you declared the variable external to...

Off the beaten path a bit, Serqiy, but what happened to your number of posts?  You were way up there and now you have less than 1000?  What'd they do? Reset...

As usual, Remi did it absolutely correct in the first reply above...

Ohhh no, no, no... we ran into that little jem... "death by SQL"...  pegged 4 cpus for two hours to do a lousy 2 minute update...  THAT was repeatable with...

Dollars to donuts says that someone change the privs on a folder or deleted a user with the privs... did you do a search for the DLL to find out...

If you have a clustered index, change it to a non-clustered index.  That'll help a highly transactional table a bit, as well, especially if you have a lot of inserts...

I found an alternative in XP... right click on the desktop, select [Properties], select the [Appearance] tab, and change the [Font Size] setting to LARGE or EXTRA LARGE.

I'm afraid that's it... if you want to change the font "size" in EM, I believe you are going to have to change the screen resolution (right click on the...

Despite the fact that it recompiles every time it is used, I've found nothing faster than the following especially since page size and page number can be parameterized in a...

SwTrans,

I guess I don't see what your problem is or what you're actually trying to do... why wouldn't the following work for you?

DECLARE @UseIt1 as varchar(100)

DECLARE @WorkQueue AS VARCHAR(100)

SET @WorkQueue...

Sushila,

You're having one of those days like I did on the trigger thing...

DECLARE @UseIt1 as varchar(100)

EXEC ('SET ' + @UseIt1 +...

Whew!  The number 6 would have really messed me up... I only have 5 fingers on each hand!

Yep... and keep in mind that SELECT/INTO only works once on any given target table unless you drop the table... but that would defeat the archive, eh