Hello,

Please try this. Not sure, if I got ur question right!!!!!!!

select sub.*,case when checked='no' then

(select final.ProductDesc from #testtable final where final.productid=sub.productid and final.isdefault=1)

else t.productdesc end as productdesc,t.isdefault ...

Hi,

May be you can try this.

WITH myCTE AS (

SELECT

...