I don't think I cover the "full" stack, but I do much of it.  I don't do the networking or user administration for our company, or work on the website,...

Thank you for the sample data and for the desired output.  Those are much appreciated.
I still don't understand how the data relates.  In the #MainTable for Group1, I see...

You could also look at the MERGE statement, which will do inserts, updates, and deletes from a source data set to a target data set in a single statement.  There...

From your post, it seems that you want to get records of how much time users spend on various activities.  You have a log of date/time events, and need to...

I think you are trying to add the results of two different calculations.  If so, then split the calculation into two individual steps, then add the results, like this.

Jeff's earlier message said, "If you're talking about 3 and 4 part naming in any of the code itself, caveat emptor. As databases grow, they sometimes move and you end...

I found this thread, and found it helpful.  I have a different solution that may help someone else.  Here is my solution.  In short,  it brings the birthdates of each...

One way to do it would be to put a "WorkloadType" column on your Orders table, and keep that field updated using the triggers you use now, rather than copying...

SELECTm.ValueField,

m.FilterColumn,-- Either "6" or "13"

r.Result

FROMMyTable m

JOIN(

SELECTt6.CategoryCode,

t13.ValueField - t6.ValueField AS Result

FROM(SELECT CategoryCode, ValueField FROM MyTable WHERE FilterColumn = 6) t6

JOIN(SELECT CategoryCode, ValueField FROM MyTable WHERE FilterColumn = 6) t13

ONt13.CategoryCode = t6.CategoryCode

)...

To calculate "average duration", convert the duration for each record to milliseconds, then average the number of milliseconds for the group. Once you have that, then add that to...

I just realized that the ROW_NUMBER() function is included in the loading script, which will not work in 2K5. This would work instead:

SELECT(TensValue * 10) + UnitsValue

FROM(SELECT DISTINCT colid...

Nice!