with data as ( select distinct prodline_id, productLineCode + ' - ' + productLine as productLine from tbl_DW_ProductHierarchy#_tableSuffix# with (nolock) where ownerId = and ownerType = and mfr_id in ( ) and prodline_id > 0 and operatorPurchasing = 'Y' ) #forJSON( 'data', attributes.datastore, 'productLine' )#