Precisely, GilaMonster.  I'd do the same when he used the Surface Area Configuration Tool against production before validating his changes in Dev/QA...

- Jeff -

If that question seems OK to everyone, how about this one:

A developer has just finished changes to a stored procedure and a table in PRODUCTION.  What's the easiest way to...

As an example of how negative experiences block out positive ones, I should point out one thing that Sears is better at than any other.  On-line replacement parts.

Pick an item,...

I gave up on Sears 15 years ago, EXCEPT, when I lose a Craftsman tool.  I'm too anal to put a non-Craftsman socket in the middle of a set.

I wrote...

Thanks, Alex, I think.

Personally, I didn't find anything mysterious.  I simply found code whose date calculations failed after 1999 and I modified that code.  I did get a lot of chuckles...

Uhh, yeah.  What Jay just said.

I have to agree with JAlexander.  While I don't know what building managers did with their elevators, I do know I spent a LOT of...

sp_grantlogin calls CREATE LOGIN anyway, so no sense in adding to the chain of events, but more important is Microsoft's declaration that sp_grantlogin may disappear entirely in future versions.  Adopting the...

Whoops.  I let my FREE T-SHIRT be my guide--and blew it!

Regarding Steve's "The Great Uproar" piece today, I have to say I hold the Featured Article to a much higher professional standard than the content of the forums.  Mr. McCown's...

By the way, DST will begin two weeks earlier and will end two weeks later.  And it's not "probably" in 2007.  It IS in 2007.  Congress will get a report...

Perhaps the question should have been, "what does this query return?"

SELECT DATEDIFF(hh, '30-Oct-2005 01:00:00', '30-Oct-2005 03:00:00')

And is that result correct?  What about stored procedures related to payrolls?  My inclination was...

A theory category is a good suggestion.  This took me way back to Relational algebra and relation calculus.

SQL DML is an implementation of relational algebra.

- Jeff -

From the question: "as well as fix the referencing aliases"

I guess the next time I get my CAR "fixed" I should expect it will disappear...

I do expect either an awfully...

I have to agree with the set-theory-non-ordered-results comments.  This question would be improved by merely adding an order by ID.

As far as real world, I have needed the previous record...

Hang in there, Steve!  While yesterday's and today's questions got off to rocky starts, the ultimate goal of these questions/discussions has been achieved.  Many of the contributors are sharp and I,...