select top #_maxItems# 'PRODUCTS' as type, 'PRD' as subjectType, skuid as subjectId, coalesce(sku,'')+' '+coalesce(skuDesc,'')+' '+coalesce(packSizeDesc,'') as subjectDesc select top #_maxItems# 'PRODUCTS' as type, 'PRD' as subjectType, skuid as subjectId, mfr_name+'
'+coalesce(sku,'')+' '+coalesce(skuDesc,'')+' '+coalesce(packSizeDesc,'') as subjectDesc union select top #_maxItems# 'OPERATORS' as type, 'OPR' as subjectType, opr.operatorid as subjectId, case when oprCompanyType = '1' then '' else '' end + coalesce(opr.companyname,'')+'
'+coalesce(opr.city,'')+' '+coalesce(opr.state,'') as subjectDesc union select top #_maxItems# 'DISTRIBUTORS' as type, 'CDR' as subjectType, cdr_recordid as subjectId, coalesce(cdr_dstname,'')+'
'+coalesce(cdr_dstcity,'')+' '+coalesce(cdr_dststate,'') as subjectDesc union select top #_maxItems# 'OPERATORS' as type, 'OPR' as subjectType, opr.operatorid as subjectId, case when oprCompanyType = '1' then '' else '' end + coalesce(opr.companyname,'')+'
'+coalesce(opr.city,'')+' '+coalesce(opr.state,'') as subjectDesc union select top #_maxItems# 'DISTRIBUTORS' as type, 'CDR' as subjectType, cdr_recordid as subjectId, coalesce(cdr_dstname,'')+'
'+coalesce(cdr_dstcity,'')+' '+coalesce(cdr_dststate,'') as subjectDesc union select top #_maxItems# 'CONTACTS' as type, 'CON' as subjectType, fspro_userid as subjectId, case when email <> '' then firstname + ' ' + lastname + '
' + email else firstname + ' ' + lastname end as subjectDesc order by type, subjectDesc (first #_maxitems#)" variable="_preparedString"> (#_groupCount#)" variable="_preparedString"> #_data#