select sku from tbl_DW_ProductHierarchy_#attributes.ownerType##attributes.ownerId# with (nolock) where skuId = #_skuId# with data as ( SELECT s.skuId, s.sku, s.skuDesc, s.sampleUnit, s.packSizeDesc, s.samplePackSizeDescSA, p.MASTER_UNIT_SIZE, p.MASTER_UNIT_SIZE_MEASURE, '#_specsheet#' specsheetLink FROM tbl_PRD_SKUs s with (nolock) left outer join tbl_PRD_Packaging p with (nolock) on p.LinkID = s.skuId and p.LinkType = 'SKU' and p.ownerId = s.ownerId and p.fsl_tablecode = s.fsl_tablecode WHERE s.skuId = AND s.OwnerID = AND s.FSL_TableCode = ) #forJSON( 'data', attributes.datastore, 'skuId' )#