declare @ownerId int = ; declare @ownerType varchar(3) = ; declare @interactionId int = ; with data as ( select sku.skuId, sku.sku, sku.packSizeDesc, sku.skuDesc, sku.mfr_name, isd.disposition, isd.saleQty, '#_quantityDisplay#' saleUOM, isd.interactionDetailId, isd.saleDurationUnit, isd.saleConfirmedBy, isd.saleConfirmedDate, isd.saleConfirmedNotes, isd.saleConfirmedFailureReasonId, isd.saleConfirmedContactId, isd.saleConfirmed, isd.comment, isd.auditRequired from tbl_crm_interactionsaledetails isd with (nolock) inner join tbl_DW_ProductHierarchy#_tableSuffix# sku with (nolock) on sku.skuid = isd.salesubjectid and sku.ownerid = isd.ownerId and sku.ownerType = isd.ownerType where isd.interactionid = @interactionId and isd.ownerid = @ownerId and isd.ownertype = @ownerType and isd.salesubjecttype = 'SKU' and isd.disposition = 'STD' ) #forJSON( 'data', attributes.datastore, "sku" )#