select operatorid, companyname, Address, City, State, zipcode from tbl_OPR_ClientOperators where mfr_BSR_id = and ownerid = and fsltablecode = order by CompanyName select stageid from tbl_SPL_Stages where OwnerId = and ownertype = and StateCode = 'o'
    select productStatusId, s.skuid, p.prodid, volumeQty, volumeTime, case when s.skuid is not null then s.sku + ' - ' + s.skudesc else p.shortDesc end as description from tbl_OPR_ProductStatus ops inner join tbl_PRD_products p on p.prodId = ops.prodId and p.ownerId = ops.ownerId and p.fsl_tablecode = ops.ownerType left outer join tbl_PRD_Skus s on s.prodId = p.prodId and s.ownerId = p.ownerId and s.fsl_tablecode = p.fsl_tablecode and s.skuId = ops.skuId and s.discontinued = 'N' where ops.ownertype = and ops.ownerid = and ops.operatorId = and purchasingStatus = 'n' and p.mfrid = order by description select osd.opportunitySubjectDetailId as skuid, spl.subjectid as prodid, spl.opportunityid, spl.StageID, cast(stg.LikelihoodPercent as float) LikelihoodPercent from tbl_SPL_Opportunities spl left outer join dbo.tbl_SPL_OpportunitySubjectDetails osd on osd.OwnerID = spl.OwnerID and osd.OwnerType = spl.OwnerType and osd.OpportunityId = spl.OpportunityID and osd.SubjectDetailType = 'sku' inner join tbl_spl_stages stg on stg.stageid = spl.stageid where spl.ownerid = and spl.ownertype = and spl.PartnerID = and spl.PartnerType = 'opr' and spl.mfrId = and spl.StageID in ()
  • #ucase(htmleditformat(companyname))#

    #address#, #city# #state# #zipcode#

    • select opportunityid, LikelihoodPercent from qryActiveOpps where skuid = or prodid = where prodid =

  • #qryAccountNBItems.description#

    Not Buying, Active #numberformat(qryMatchingOpps.LikelihoodPercent*100,"99")#%Not Buying  Avg Units: #qryAccountNBItems.volumeQty# #qryAccountNBItems.volumeTime#

    add

    •