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

Lee,

You used the key words "query the dataset".  Cursors contain a bunch of rows but they can only be worked on or "fetched" one agonizing row at a time.  If...

Sure you do... "Old" = Parent, "New" = Child.  It's a classic hierarchical problem.  There has to be a dozen good articles and lot's of good posts on this forum...

I believe that what you are looking for may be solved with "dynamic SQL".  There has to be a thousand good postings on this forum about it... try a search...

I've found the even Microsoft uses the "undocumented" features   Works for me!

Concure with that... isn't there an autonumbering column or a date/time column or a consecutive ID column of any sort?  How about a clustered primary key?  There has to be something...

I've never seen it fail either (and it's been 10 years)... however, the first article says it's guaranteed to be OK if you create the table with the IDENTITY column...

Thought I'd throw my 2 cents in here because lot of folks run into some real problems when using ranges of dates as criteria...

BETWEEN is fine for date ranges......

Sorry... was in a hurry and forgot that you were using a cursor and I...

Yah... forgot that the NTEXT data type is being used... sorry.