select name purchasingTableName from sysobjects with (nolock) where name like 'tbl[_]DW[_]OperatorPurchasing[_]MFR%' and xType = 'U' and name != 'tbl_DW_OperatorPurchasing_MFR0' and name != 'tbl_DW_OperatorPurchasing_MFR6500' with purchasing as ( union select m.mfr_name, m.mfr_id, p.operatorName, p.quantityAmt, m.unitOfMeasurePlural quantityUnit, p.quantityTime, p.purchasingStatus, p.reason, p.skuId, p.sku, p.skuDesc, p.prodId, p.product, p.shortDesc, p.lastPurchaseMonth from #purchasingTableName# p with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = p.ownerId and 'MFR' = p.ownerType where p.cho_id = ) select * from purchasing order by mfr_name, product, sku for json path, include_null_values