Home Forums SQL Server 2008 T-SQL (SS2K8) Proplem Put Filter ("And" or "Or") in Query RE: Proplem Put Filter ("And" or "Or") in Query

  • September 5, 2013 at 5:45 am

    #1647659

    You need to change the HAVING clause to get your desired results. With the code below you can check if both 'Walker' and 'Cane' exists at least once.

    HAVING sum(case when NameTools = N'walker' then 1 else 0 end) > 0

    AND sum(case when NameTools = N'Cane' then 1 else 0 end) > 0

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **