4 Replies Latest reply: May 23, 2017 2:51 PM by Vishwarath Nagaraju RSS

    Using Where in Scripts

    Tom Soley

      I am trying to add a 2nd where clause in my load scripts to bring back claims that are only Open and Closed and I keep getting a load error, below is how I have it now...

       


      SQL SELECT *
      FROM
      "ACT_DBASES_PROD".dbo."WC_CLAIM_ADJUSTERS"
      Where (
      [SNAPSHOT_CCYYMM] >='201701') AND
      Where Match (
      [CLAIM_STATE]='Open','Closed')