Hi,

I used case as below but im getting error

select Pay.DetailId, clm.AssetId,

case when Pay.DetailId IS null then isnull(clm.NoteIds,0) else isnull(pay.NoteIds,0) end...