Compare text

Find the difference between two text files
Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools

Untitled diff

Created Diff never expires
5 removals
31 lines
13 additions
39 lines
WITH t AS (
WITH t AS (
SELECT u.pkBenID,
SELECT u.pkBenID,
s1.pkSiteID,
s1.pkSiteID,
s1.ParentID,
s1.ParentID,
s1.Name,
s1.Name,
s1.Icon,
s1.Icon,
s1.link
s1.link,
rs.fkSiteID as rsSiteID
FROM users u
FROM users u
INNER JOIN sites s1

LEFT JOIN Role_Sites AS rs
ON u.fkRoleID = rs.fkRoldeID

LEFT JOIN sites s1
ON u.fkSiteID = s1.pkSiteID
ON u.fkSiteID = s1.pkSiteID
--WHERE u.pkBenID = '215'
WHERE u.pkBenID = 'ABSY1XFY43NKRJI46'
UNION ALL
UNION ALL
SELECT t.pkBenID,
SELECT t.pkBenID,
s2.pkSiteID,
s2.pkSiteID,
s2.ParentID,
s2.ParentID,
s2.Name,
s2.Name,
s2.Icon,
s2.Icon,
s2.link
s2.link,
t.rsSiteID
FROM sites s2
FROM sites s2
INNER JOIN t
INNER JOIN t
ON s2.ParentID = t.pkSiteID
ON s2.ParentID = t.pkSiteID
OR s2.pkSiteID = t.rsSiteID
WHERE s2.pkSiteID != t.pkSiteID
WHERE s2.pkSiteID != t.pkSiteID
)
)
SELECT t.*,
SELECT t.*,
f.*
f.*
FROM t
FROM t
LEFT JOIN SitesFunctions sf
LEFT JOIN SitesFunctions sf
ON t.pkSiteID = sf.fkSiteID
ON t.pkSiteID = sf.fkSiteID
OR t.rsSiteID = sf.fkSiteID
LEFT JOIN Functions f
LEFT JOIN Functions f
ON sf.fkFuncID = f.pkFuncID
ON sf.fkFuncID = f.pkFuncID
ORDER BY t.pkBenID,t.pkSiteID
ORDER BY t.pkBenID,t.pkSiteID
Saved diffs