Without schema, I can't hand you actual code, but what's the concern doing something like the following:
SELECT
BldgID,
UserID,
Max(SomeDate) AS MaxDate,
Min(SomeDAte) AS MinDate
FROM
-- Joins go here
GROUP BY
BldgID,
UserID
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA