And also the global temp table is not needed at all. For example:

DECLARE @dd1 datetime = dateadd(year, -1, getdate());

DECLARE @SQLString NVARCHAR(4000);

SET @SQLString = N'

select t.name, t.object_id

from sys.tables t

where...

You should not do any string concating. If you're going to use sp_executesql, then use it properly and specify the date as a parameter.

DECLARE @SQLString NVARCHAR(4000)

SET @SQLString = N'

SELECT...

In fact, you will always have holes in the sequence. For example if you do a rollback after an insert, the value will not be reset, even though the row...

If an exam question explicitly states "cross join is not allowed", they're probably asking for you to show that there is another 'construct' in SQL that accomplishes the same result...

Actually no. The code was intentionally presented as a picture for 2 reasons:

1...

ladyblue1075 (3/8/2012)

I'm writing a script that will update selected multiple rows of records I got from my EXCEPT select.

I wrote this:

UPDATE t1

SET t1.col1 = t2.col1, t1.col2 = t2.col2, t1.col3...

To finalize this: My explanation is wrong and my question + answer was correct only by luck.

The proper explanation has been given in this thread. To be sure I am...

So am I, as I was very sure I had tested...

I see your point. I have to get back on this or maybe someone else sees what's wrong?

You have left off half of the explanation in your quote. In the next sentence the use of parenthesis to override this behavior is explained:

To preserve duplicates in only a...

Provide us a table definition (so we can create a table similar to yours) plus a script to fill it with some test data. That way we can see for...

I did...

Or use a free proxy server somewhere on 'the net'. This article is an absolute 'must read' related to your work. You should not have to read it from home.

The Cad-method assumes that the newID always higher is than the oldID. This may very well be true, given that the ID is likely implemented as an identity column, but...

Disregarding the fact that indeed create date is normally before the modification date, it is easy to determine the latest of two (or more) date values from a single row...