I confessed! I have used the "DISTINCT" modified.

Why? Because I have to crank out the code ASAP and I don't have the time to worry about the problems in your...

A trigger in this instance would hardly bring the system to its knees.

A trigger doesn't participate in a SELECT.

The entire article concerns the handling date queries.

I suggested an approach that...

Hmm... You may suffer a huge performance hit if you use DATEDIFF().

SQL SVR may have to perform a full table scan. Not exactly what one

desires in a production system.

I...

This code is considerably faster:

Declare @X int

Set @X = 0

Select @X = @X + 1

From master.sys.columns c1

Cross Join master.sys.columns c2

Print @X

SQL 101 - Always make sure your tables have indexes to avoid full table scans.

Looks as though the DBA and/or developers need a little coaching.

First, you need to understand your data.

Exactly what makes anyone record the "unique" or desired record?

Does the table have an IDENTITY column or a datetime column

that could be used to...

Wouldn't sp_makewebtask and sp_runwebtask also work for you?

How about SQL Reporting Services?

Also to identify users who are using SQL 2005 Studio

Add this program name to the filters

'Microsoft SQL Server Management Studio - Query'