Cool..

Removing the NOLOCK did return unique data from the DISTINCT.

Thanks everyone for the help and great informations. 🙂

Thanks for replies..

I think i forgot to mention one important thing, Table_Main has an unique index on for Col_A and Col_B..

does this mean the query did an Index Scan...