I don't see anything from "hist" table in SELECT list, so it must be either removed from query or INNER JOINed if it's used as a filter for transaction records.

bledu's...

Boy, you better don't start.

You're not the first one who was trying...

No survivors so far.

You...

CHAR(1)

Would it be better to have 1 file per table?

set @cmd = 'sqlcmd -E -dWatauga_Test -SNV-DEVSQL1\DAPHNE -Q"exec SP_GENERATE_INSERTS '+@TAB_NAME+'" > "c:\' + @TAB_NAME + '.sql" '

Separate files will allow you...

My 2 pence for Adam.

Datetime field does not have any format.

So, there is nothing to change.

In fact datetime is FLOAT value reflecting number of days (including fraction) passed since the...

Yeah, Grant, it's really amazing.

Such a simple quiz brought so many unexpected points.

Case 1 do one thing, Case 2 do another, Case 1 and 2 combined, do a third.

Problem...

There is also nothing wrong with inserting into #Table with IDENTITY column (with desired order of records) and returning result from that table.

In fact any of posted solutions creates temp...

Jim,

check you flow.

Error in INSERT does not prevent execution of UPDATE.

Moreover, because your transaction is already rolled back either ROLLBACK or COMMIT will cause an error.

And I don't see where...

You should fix INSERT, not SELECT.

> must've been that old donut I ate this morning

Mmmmm... Dooonut...

Jeff,

It seems you overcomplicated the last query.

This returns the same result:

SELECT t1.*

FROM #GdsSellPriceDet t1

LEFT JOIN #GdsSellPriceDet t2

...

Where your post with CASE from previous page?

That one you were referencing when saying

"3. You were not exactly right about CASE." ?

Cheater always remain cheater.

Can you define which row to be considered "first"?

There is no natural physical order of rows in tables.

Grant, I quoted you quiz and it made me reread you article.

You ruled out solution from Chris and did not realize that he just accurately implemented the logic you requested...

Your code does not implement the logic of query correctly.

If you cannot get it even after you've been pointed...

Sorry.

Write code that counts from 1 to 100 For each number evenly...