Yes. They both work fine. I just changed the query to cast the sum values as float before I sum them, and that avoids the error. So...

Ashka, to answer number 4. With a Calendar table you can use ...

Select * from Calendar

Where Q=3 and Y=2009 and dw=5

to get all of the Fridays in the...

Doh, thanks for letting me know. Since this is in the SQL 2005 section, no help then.

Sorry for the misinformation.

The above suggestions are much preferred, but you should also be able to tell from the transaction logs, if you have backups you can access.

Try this software from redgate...Redgate SQL...

I think Toad for SQL Server may have this functionality. I use Toad, but haven't tried the debugger. It has some great features, including multiple sets of query...