1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| select entityid from (
SELECT
DEA.EntityId
FROM DEALER_PROFILE DP
Join DEALER_ENTITY_ACCESS DEA ON DEA.DealerID = DP.ProfileId
INNER JOIN dbo.DEALER d ON d.dealerid = DP.dealerid
where DP.ProfileId =@pid
--and DP.dealerid =@did
) t1
group by entityid
except
select entityid from (
SELECT
DEA.EntityId
FROM dbo.DEALER_ENTITY_ACCESS DEA
INNER JOIN dbo.DEALER d ON d.dealerid = DEA.dealerid
where DEA.dealerid =@did
UNION
SELECT
DEA.EntityId
FROM DEALER_PROFILE DP
Join DEALER_ENTITY_ACCESS DEA ON DEA.DealerID = DP.ProfileId
INNER JOIN dbo.DEALER d ON d.dealerid = DP.dealerid
where DP.dealerid =@did
) t1
group by entityid |
