Lynn Pettis - Tuesday, November 21, 2017 10:35 AM

zach.routt - Tuesday, November 21, 2017 10:31 AM

Hi there,

I need help with a query to remove a record from a data set. I need to remove BranchNumber 44 and TillNumber 20 from the results? Below results in all BranchNumber 44 results and TillNumber20 being removed.
SELECT [BranchNumber]
  ,[TillNumber]
  ,[Denom_1]
  ,[Denom_2]
  ,[Denom_5]
  ,[Denom_10]
  ,[Denom_20]
  ,[Denom_50]
  ,[Denom_100]
  ,[Denom_Coin_1]
  ,[Denom_Coin_5]
  ,[Denom_Coin_10]
  ,[Denom_Coin_25]
  ,[Denom_Coin_50]
  ,[Denom_Coin_100]
  ,[TotalsDenomId]
FROM [R131_Platform_1318Prod].[dbo].[TotalsDenom]
WHERE Denom_1 > 200 And
TillNumber IN
(
  90,
  91,
    92,
    93,
    10,
    20
    )
    and BranchNumber Not In (44) and TillNumber Not In (20)

Try this:
SELECT [BranchNumber]
 ,[TillNumber]
 ,[Denom_1]
 ,[Denom_2]
 ,[Denom_5]
 ,[Denom_10]
 ,[Denom_20]
 ,[Denom_50]
 ,[Denom_100]
 ,[Denom_Coin_1]
 ,[Denom_Coin_5]
 ,[Denom_Coin_10]
 ,[Denom_Coin_25]
 ,[Denom_Coin_50]
 ,[Denom_Coin_100]
 ,[TotalsDenomId]
 FROM [R131_Platform_1318Prod].[dbo].[TotalsDenom]
 WHERE Denom_1 > 200 And
 TillNumber IN
 (
 90,
 91,
 92,
 93,
 10,
 20
 )
 AND NOT (BranchNumber = 44 and TillNumber = 20);