November 21, 2017 at 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)
November 21, 2017 at 10:35 am
zach.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);
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.
November 21, 2017 at 10:56 am
zach.routt - Tuesday, November 21, 2017 10:37 AMLynn 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.
Glad to help. Just an FYI, there is another way to write the last part of the query, if I did my Boolean logic correctly:
AND (BranchNumber != 44 or TillNumber != 20);
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply