Using Where in Scripts

[Anonymous]

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')

[sunny_talwar · Accepted solution]

May be try this

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

[Anonymous]

Thank You Sunny that worked!!!!

[sunny_talwar]

Awesome

[vishsaggi]

Hello Tom,

Can you close the thread by marking Correct answer you got.