id voucherid orgid perid listtype 14 10 0 0 0 15 10 0 203986 0 16 10 151735 0 0 19 9 0 203986 1 20 9 151735 0 1
DECLARE @per int DECLARE @org int SET @per = 203986 SET @org = 1517351 SELECT * FROM [voucher2contact] WHERE [perid] <> @per AND [orgid] <> @org AND listtype = 1
id voucherid orgid perid listtype 20 9 151735 0 1
-- listtype 0 ->Whitelisted -- listtype 1 ->Blacklisted -- Return not Blacklisted entries for @per + @org
DECLARE @per int DECLARE @org int SET @per = 203986 SET @org = 151735 SELECT * FROM [ERA].[dbo].[voucher2contact] WHERE ( ( ([perid] <> @per AND [perid] > 0) ) OR ( ([orgid] <> @org AND [orgid] > 0) ) )AND listtype = 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)