Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- a.uniqueid,
- a.siteid,
- a.FileUrl,
- --b.siteid,
- --b.webAppUrl,
- --b.siteUrl,
- max(left(b.webAppUrl,len(b.webAppUrl)-1) + b.siteUrl) as webAppUrl_SiteUrl
- from
- a,b
- where
- a.FileUrl like left(b.webAppUrl,len(b.webAppUrl)-1) + b.siteUrl + '%'
- group by
- a.uniqueid,
- a.siteid,
- a.FileUrl
- order by webAppUrl_SiteUrl desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement