Thanks for your response Vasc...

The statement works perfectly and retrieves the data as I wanted it...

What are some good books on t-sql programming?

Thanks,

GP

Thanks so much for the quick response. That makes perfect sense.

As I'm learning more t-sql, the power of the language is quite amazing...

If i understand correctly, the sum and the...