You should still be able to get that from the call to vp_wfcaudit right after that sub-query, where it's alliased as "a".

You should take a look at the DateName function. It will return the name of the day of the week for you. And it'll be faster than the...

Steve, I can't remember if geo-heating/cooling has been mentioned before in your energy update posts. Is that something you've thought about? It generally pays for itself in a...

I don't think Visual Studio will step through an SQL proc. Management Studio for SQL 2008 will do that, but I don't think VS will do it for 2005....

Look up triggers in Books Online or MSDN. Either one will give you the data on how to write them.

Not really. It does what it's supposed to.

So long as the XML doesn't have multiple nodes, you can put the XQuery portions of the second query right into the first query. I thought you were going...

Try changing that part to this, see if it gets you what you need:

inner join

(select -- get max Supervisor Approval...

You can create a database diagram in Management Studio. If you want to e-mail it to someone, print it as a PDF, attach it to the e-mail, and away...

You can use the XQuery modify function for that. Books Online has details and a couple of examples.

This is a duplicate thread. Please don't post the same question in multiple forums.

Nope. I don't understand what your second query is supposed to do, so I really can't do much with it.

I'm not a report designer, but I'm sure you can get the whole recordset to show on the report. I'm not sure why it would only show the total...

There might be a way to hack it, not sure. I know you could stop the SQL service, save your database and log files, unistall SQL and reinstall it....

I think you'd just have to uninstall SQL 2000, or otherwise make sure it's not in use. You're more correcting an error you made the first time around, since...