Take a look at this thread:

Truncate All Tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341

Just remember that everything is a cost vs. benefit decision.  It is really a matter of deciding where to spend the money, and that depends on your application.  For example,...

It would also be helpful if the Active Topics highlighted topics I have already posted on.

Your case statements produce null results when the values are equal.  Even if you correct the logic, it is more difficult to scale it up for more columns (x-way min), while the subquery...

The Active Topic problems really makes answering questions on the forums a lot harder to do, because it's so much work to locate new postings.  It's a big reason why I spend much...

I had a guy get up and leave in the middle of an interview, because he thought the job was beneath him.  A couple of years later, he came...

Either of these commands will change the SA password in 2005.  SP_PASSWORD works with earlier versions of SQL Server.

exec sp_password  @new = 'MyNewPassword' , @loginame = 'SA'

alter login SA with...

There is always a shortage of top talent for any job.

There is always a plentiful supply of second-rate talent and just plain incompetents for any job.

There is never a...

You can create a user table with a column of type SYSNAME.  I just ran this code OK in SQL 7.0, 2000, and 2005:

create table MyTableWithSYSNAME ( MySYSNAME sysname not null...

The last Friday of a given week?  Do you have weeks with more then one Friday?

Maybe I should start a new thread for this, but I find the Active Topics feature almost unusable.

If there are more than 15 topics on a page, it gives you...

A server name, database, login, user, table, view, stored procedure, function, etc. are only restricted to having names that are SYSNAME (NVARCHAR(128)).

Just because your current names...

Jeff, I think you need to check that formula.  It produces values in the range of -5 to +5:

(ABS(CHECKSUM(NEWID()))%11-5)

This may be closer to what you are suggesting.  It produces values in...

Here is a way to do it with a subquery.  It may be handier to do it this way, because it does not require the main query to be grouped. ...

Good guess on my part, huh?

My experience is that posts like this are almost always looking for a conversion to/from UNIX time, so I took a shot at it.