I'm curious about why you used minutes rather than hours for the...

You mean like Count(DISTINCT...

It uses the "quirky update". Jeff Moden wrote an article about the quirky update.

Drew

My issue with defining it as multiple tables is that you lose the fact that the order is important when you start introducing outer joins. Consider the following example:

WITH...

Actually, this is like Wave/Particle duality. In some situations, it helps to think of the joins working on multiple tables, but in other situations it helps to think of...

The purpose of EXCEPT is to handle set...

You may also need to use dynamic SQL. It's really difficult to tell without DDL, sample data, and expected results to work with.

Drew

Depending on the complexity of your query, you could try FOR XML AUTO, ELEMENTS or FOR XML PATH('some value') instead of XML EXPLICIT.

Drew

Your data is missing the decimal point whose sole purpose is to indicate which part is the integer portion and which part is the decimal portion. By convention, the...

This sounds suspiciously like a homework assignment. The answer to this question is easily found with a little research. The fact that you didn't find it suggests that...

Your row number is only partitioned by the Systalk_ID, but the grouping in the outer query is based on Systalk_ID, Attendance_Type, and SC_Attendance_ID. You want these to match.

Drew

This should get you close to what you are looking for. Essentially it takes the intersection (A) of two sets (B) and (C) and adds the values to the...

There is a perfectly good datatype that is optimized for working with datetime data. ...

From what I understand, there is some overhead for every transaction. With a set-based query, this overhead is performed once; with a cursor, this overhead is performed for every...

I think I found the problem. Your original query was only grouping on the Customer Number, but you want to group on the Order Number as well. Otherwise...