declare @ownerId int = ; declare @ownerType varchar(3) = ; with defaultDispositions as ( select * from tbl_CRM_Dispositions with (nolock) where ownerId = 0 and ownerType = '*' and dispositionType = 'D' ), dispositions as ( select dd.dispositionType, dd.dispositionCode, coalesce( d.dispositionDesc, dd.dispositionDesc ) dispositionDesc, coalesce( d.saleState, dd.saleState ) saleState from defaultDispositions dd left outer join tbl_CRM_Dispositions d with (nolock) on d.dispositionCode = dd.dispositionCode and d.dispositionType = dd.dispositionType and d.ownerId = @ownerId and d.ownerType = @ownerType ) #forJSON( 'dispositions', attributes.datastore, 'dispositionDesc' )#