Skip to content

Instantly share code, notes, and snippets.

@saltlakeryan

saltlakeryan/temp.sql

Last active September 15, 2016 19:19
Show Gist options
  • Save saltlakeryan/51046dd86c0447c9f00d2aeeb0bef254 to your computer and use it in GitHub Desktop.
Save saltlakeryan/51046dd86c0447c9f00d2aeeb0bef254 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
temp.sql
SELECT a.NAME,
b.COLLECTIONID,
sum(c.FILE_FILESIZEBYTES)
FROM V201_RPT00.COLLECTIONS_VIEW a
LEFT JOIN V201_RPT00.COLLECTION_MEMBERS_VIEW b on a.SOMEID=b.SOMEOTHERID
LEFT JOIN V201_RPT00.FILES_INFORMATION_VIEW c on b.SOMEID=c.SOMEOTHERID
GROUP BY a.NAME,
b.COLLECTIONID
ORDER BY b.COLLECTIONID ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment