You don't make it count down. Add a datefield with default getdate().

Then the query would be something like this :

Select * from dbo.MyTable where DateField between dateadd(HH, -2,...

This is something I did for someone who wanted to find the unused dbs in its mssql/data directory.

You should be able to adapt this script yourslef :

--list the database...

Yup, that's almost as sneaky as Noeld's solution to join to stored procs .

Read my previous post carefully, execute the code one part at the time if you need to. This can handle any number of cities at the same time. ...

Yes, it can create locks in tempdb and grind the server to a halt (Less likely with 1=0).

If you need a table, script it out and execute that script when...

Damn, I saw that but I thaught there was 4 variables but there are only 3.

Using the profiler would have caught that .

That's almost what I had but I wasn't sure of the relations....

Why would the alias make this work (even if it does, I don't see why it is required)??

One could argue that if they had coded the app correctly in the first place (returning as little rows as possible), unicode or not, the problem wouldn't have been there.

Are all the files in the same directory?

Not too sure (think I don't see all the tables/relation in this).

How about this ? :

Create a new view using enterprise manager.

Select all the tables you need (to display...

Always another way to skin the cat .

On board with the not doing it in production part??

Did the vba code I sent you worked, because other than that I have no clue of what the problem can be?

The last thing I can imagine to see the...

I don't have the script to prove this, but even the table variable is created in tempdb. It really all depends on the needs of the moment and the...

Yup... still only one where keyword is allowed per select .