Hi All,

Thanks for the responses.

I think i have a solution based on grambowk  T-SQL code(see below).

I am not sure if what i have...

Thanks Frank

I have a better understanding of it now

Shane

Thanks a million Frank

That is exactly what i was looking for.

My SQL is not the strongest but could you tell me(or point me to a site) what the signifacnce of...