This is because of SQL Servers datatType precedence (check out the topic in Books Online). All the numbers in your calculation are integers so it performs integer arithmetic. If you...

I'd also be questioning the use of the text field in the table. Surely the person viewing the aspx page isn't going to type 2k worth of text into a...

Ugg ... "The problem arises when there is more than one distinct value" ... then this wouldn't be a distinct value...

Semantics aside, if you have to nest cursors then I'd...

For starters the subqueries you're using for TotalHours, TotalDays and TotalWeeks

(SELECT     COUNT(DISTINCT (datepart(ww, session_start_time)))
  FROM         ...

Is this instead of using workflow scripts? If so, that is a really neat idea. I've always hated how the workflow scripts are "hidden" away.

?? logistical nightmare to add the steps.

This runs through all jobs on the server. You could modify it a bit to exclude jobs and maybe put it in a proc...

Can you elaborate on what you mean when you say "the values go haywire"?

Are the values different, or are they just presented differently.

I've noticed with my reports that export to...

Unless I'm missing the same thing you are they do seem to perform the same function.

I haven't tried this but maybe it's something to do with the roles. Possibly a...

Bear in mind that if you run the Standard Edition, you still have to buy a license. If you use Enterprise Edition, you can have as many instances as possible.

Even better.

Use the custom DTS FTP task from SQLDTS,

http://www.sqldts.com/default.aspx?302

Unlike the standard FTP task, this one allows sending and receiving of files instead of fiddling around with external .CMD files.

Good stuff. A lot of potential here for answering many of the "easy" questions where people get told to read BOL. Nothing better than actually seeing something in action.

My .02...

Art

Take a look at my home grown ASP page over at the Australian SQL Server User Group.

http://www.sqlserver.com.au/resources/ViewResource.aspx?resourceId=9

We use this page in conjunction with Servers Alive!

http://www.woodstone.nu/salive/

Just to echo the general consensus, you should not make it a practice of updating any of the system tables.

You could have achieved your fix by scripting out the jobs,...

If you post your table structures and the queries you are running you might get a better response than "It depends..."

Certainly SQL Server has no problem updating 600,000 records, depending...

Are you sure there are no duplicates in Query Analyzer? Change your query to perform the same grouping operation the RS is doing.