Home Forums SQL Server 2014 Development - SQL Server 2014 Query to omit single record based on data from two columns? RE: Query to omit single record based on data from two columns?
November 21, 2017 at 10:37 am
Lynn Pettis - Tuesday, November 21, 2017 10:35 AMzach.routt - Tuesday, November 21, 2017 10:31 AMHi 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);
Perfect thank you so much. I knew I was just overlooking something.