with data as ( select distinct skuId, sku + ' - ' + skuDesc as sku from tbl_DW_ProductHierarchy#_tableSuffix# with (nolock) where ownerId = and ownerType = and mfr_id in ( ) and operatorPurchasing = 'Y' ) #forJSON( 'data', attributes.datastore, 'sku' )#