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 2, 2013 at 6:48 am

    #1646736

    Hi Test This Query

    Select * From

    (

    SELECT FirstName

    , LastName

    , CompanyID

    , NCode

    , FatherName

    , nPercent

    , NationalCode

    , (select COUNT (*) From Tools_Information K Where K.NationalCode = R.NationalCode And K.NameTools = N'Cane')COUNT_cane

    , (select COUNT (*) From Tools_Information K Where K.NationalCode = R.NationalCode And K.NameTools = N'Walker')COUNT_walker

    FROM View_Report R

    GROUP BY FirstName

    , LastName

    , CompanyID

    , NCode

    , FatherName

    , nPercent

    , NationalCode

    )V

    Where (Isnull(V.COUNT_cane , 0) > 0 And Isnull(V.COUNT_walker,0) > 0)