• CTE can be modified to select non duplicate values .

    Please Refer,

    http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx