Multiple Criteria store proc - need a bit of help

• Ric-399929

  SSChasing Mays

  Points: 648

  More actions

  May 4, 2007 at 1:43 pm

  #176183

  I need some help writing my store proc, I tried both of the following but it does'st seem to work.  Your suggestions would be appreciated.

  SELECT count(LeadId)

  FROM dbo.Cl_Leads

  Where AccntMng=@AccntMng and (Status = 'Won' or Status = 'Lost') and InsertDate BETWEEN @dtStart AND @dtEnd

   I also tried

  SELECT count(LeadId)

  FROM (SELECT * FROM dbo.Cl_Leads WHERE InsertDate BETWEEN @dtStart AND @dtEnd)

  Where AccntMng=@AccntMng and (Status = 'Won' or Status = 'Lost') 

  This return and error: Incorrect syntax near the keyword 'Where'.

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  May 4, 2007 at 2:05 pm

  #704468

  Post the whole proc, the ddl for the table, some sample data, and the errors you received (stick with the first syntax).

   

  ---

  And then again, I might be wrong ...
  David Webb