You can run through the tutorials at http://www.w3schools.com/sql/ to get a general idea. SQL is the same, it doesn't matter what application is running on top of it so any tutorials about SQL should help. As far as the tables you'll need for that query, you should only need the projects and documentsinprojects tables, and it is quite possible. Concepts you'll definatly need to understand are:
Inner join: http://www.w3schools.com/sql/sql_join_inner.asp
You can also buy this book by Kathi Kellenberger - Beginning T-SQL 2008
She has a series of videos online that are quite helpful and can teach you enough to be dangerous.
The key is you need access to SQL Server Management Studio and the database server.
You can also find her videos here: (start from the bottom up)
1) Speak Like a T-SQL Developer by Kathi Kellenberger
2) Writing Simple Select Statements by Kathi Kellenberger
3) Writing Simple Select Statements – Part 2 by Kathi Kellenberger
4) Writing Simple Select Statements – Part 3 by Kathi Kellenberger
5) Joining Tables Part 1 by Kathi Kellenberger
6) Joining Tables Part 2 by Kathi Kellenberger
Then you can work on more advanced topics: (skip the ones about writing - IT'S NOT ALLOWED :-) )
7) Introduction to Common Table Expressions by Kathi Kellenberger 8
) Aggregrate Queries in SQL Server T-SQL for Beginners by Kathi Kellenberger
Good luck, Joy
What happens to the old SWW presentations. Currently, only presentations from 2014, 2013 an 2012 are selectable. Can I still acces them in the future?
All 3 answers sound like they are Correct.
The script I wanted was already created, see this blog. http://blog.inflow-tech.com/inflow/2014/02/how-to-find-folders-with-large-file-counts-in-solidworks-enterprise-pdm-after-a-file-migration-into-epdm-it-is-sometim.html