Actually, the "Service startup account" area is greyed out now. I can't change it to anything.

I was a disbeliever, it's true!

I ended up going with a temporary table, though, before that reply was posted. It was just a little easier for me to do.

Thanks again...

"Divide by zero error encountered."

If the user doesn't have any stats matching the criteria, it will bomb on 0. I guess it's back to temprorary tables, then. The current solution...

should this line:

cast ((sum(btipages) / sum(datediff(second, btiin, btiout)/ 60 / 60) as varchar(20)) as vperhour

be more like this?

rperhour = (sum(btipages) / sum(datediff(second, btiin, btiout)/ 60 / 60))

I tried it this...

That looks right, but I keep getting errors:

Server: Msg 156, Level 15, State 1, Line 10

Incorrect syntax near the keyword 'as'.

Server: Msg 156, Level 15, State 1, Line 18

Incorrect syntax...

Here's an example of what it kicks out.... I'd like to be able to order by most/least in a category and/or username.

username vperhour sperhour cperhour rperhour

-----------...

Thanks for your suggestions. I'm very very new to all this. I've only been using SQL for a couple months and I've never done any programming to speak of. Here's...

Also, if I have a string of select statments put together using UNION, is there a way to sort the result set?

Maybe something like ((select x, y from a) union...

I thought so and also thought I had already set things up correctly. Someone had changed the login for the NT account for SQL to use but did not change...

It was actually kind of embarassing and irrelevant, which is why I didn't post the answer, but here it is:

The ASP pages in question were apparently ALSO pulling data from...

nevermind... i figured this one out.

I think that will do it. I should have guessed it would be something simple. Thanks for your help.

Thank you all for the suggestions. I'm going to try some different things based on your ideas.

One more question... I somehow created a trigger with a name like "test_...

Thanks for the replies. Keep in mind that I am *very* new to this so any additional comments you might have on my code would be appreciated.

trigger 1...

CREATE TRIGGER [hist1]...