CASE
WHEN(P.PropertyId=115)
THEN
''
ELSE
CASE
WHEN R.CompanyId is not null and R.CompanyId>0
THEN CASE WHEN R.IsSeleComContForConfi = 1
THEN
AA.Pincode
ELSE
A.Pincode
END
ELSE
A1.Pincode
END
END AS [Pincode]
No comments:
Post a Comment