Hey, Hey!  With the biggest smile on my face, I say thank you!!  Your suggestion worked perfectly stax68.

Noel,

You are right....I need the BatchDateTime in the GROUP BY.  I've been out of the office since last Wednesday so I haven't had the opportunity to work on this much.  I did,...

Aaron - I tried your suggestion but received the following message.  I added the alias but the results didn't group by InsGroupID.  Any other ideas?

Server: Msg 107, Level 16, State...