select broker_id, broker_name from tblBrokers with (nolock) where exists ( select * from tbl_PRD_Skus where ownerId = broker_Id and fsl_tablecode = 'BRO' and mfrId > 0 ) order by broker_name

Select a Broker #htmleditformat( broker_name )#

select b.broker_name, m.mfr_name, s.sku, s.skuDesc, coalesce( pkg.scc14, '' ) as GTIN, count(distinct isd.interactionId ) salesCalls , case when s.mfrSKUIdStatus = '?' then 'Unknown SKU' when s.mfrSKUIdStatus = 'M' then 'Managed Access: MFR' when s.mfrSKUIdStatus = 'B' then 'Managed Access: BRO' when s.mfrSKUIdStatus = 'X' then 'Not Syndicated to 1FS Brokers' else coalesce( s.mfrSKUIdStatus, 'Not Checked' ) end as reason from tbl_PRD_SKus s with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = s.mfrId inner join tblBrokers b with (nolock) on b.broker_id = s.ownerId inner join tbl_CRM_interactionSaleDetails isd with (nolock) on isd.ownerId = s.ownerId and isd.ownerType = s.fsl_tablecode and isd.saleSubjectType = 'SKU' and isd.saleSubjectId = s.skuId left outer join tbl_PRD_Packaging pkg with (nolock) on pkg.ownerId = s.ownerId and pkg.fsl_tablecode = s.fsl_tablecode and pkg.linkId = s.skuId and pkg.linkType = 'SKU' where s.fsl_tablecode = 'BRO' and s.ownerId = and ( s.mfrSKUId is null or s.mfrSKUId <= 0 ) group by b.broker_name, m.mfr_Name, s.sku, s.skuDesc, pkg.scc14, s.mfrSKUIdStatus order by b.broker_name, m.mfr_name, count(distinct isd.interactionId ) desc select broker_name from tblBrokers where broker_id =