This is hilarious.  Why?

Because in light of SOX all kinds of interpretations have arisen as well as companies claiming to "know" just how to implement SOX.  Nowhere, and I mean...

Guys, I believe is asking to return a "pivot" result. 

The statement "SELECT  TOP 1 *

FROM Contact C

INNER JOIN ContactPoint CP ON C.ContactID = CP.ContactPointID"  does not return...

Thank you Phil, I learned something today

Here you go friend.   Right out of BOL, I made the join and used max instead of sum.  Sorry for the crappy formatting, but I am tired

While your idea is valid, I think you might not be considering the *big* picture.

Read the following article, this is good info:

http://www.quest-pipelines.com/newsletter-v5/0204_B.htm

There are two statements he makes that you...