CREATE PROCEDURE sp_Portals

@Ref as nvarchar(255),
@SDate as Decimal(18,0),
@EDate as Decimal(18,0)


AS

SELECT     COUNT(b.Pcode) AS totclicks, 
case when b.Pcode = 'NPF'  then  b.Pcode + '-- No Products Found'

else a.prodmodel
end as prodmodel,
SUM(c.orderTot) AS [Sales Total], 
COUNT(c.cusID) AS NumSales,

b.Pcode as  Code

FROM         CusDetails c RIGHT OUTER JOIN
                      View1 b LEFT OUTER JOIN
                      Products a ON COALESCE (b.ProdID, 0) = a.ID ON c.sessID = b.SessID
WHERE     (b.Referer LIKE '%' + @Ref+ '%') AND (b.theDate >= @SDate) AND (b.theDate <= @EDate)
GROUP BY b.Pcode,  a.prodmodel
ORDER BY totclicks DESC
GO

quote:

---

Originally posted by visakh16

Use NOT LIKE

---