Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise Programming
  • Product Communities
  • Developers and Programming
  • ProjectWise Programming
  • Cancel
ProjectWise Programming
ProjectWise Programming - Blog
    • Sign In
    • Subscribe by email
    • Posts RSS
    • More
    • Cancel
    Blog - Monthly Archive List
    • January 2020 (1)
    • November 2015 (1)
    • February 2014 (1)
    • Tags
    • Subscribe by email
    • More
    • Cancel
    • Create A Database View In SQL Server That Will Contain The Path For A Given “Folder Id”

      Dan Williams
      Dan Williams

      I have been trying to figure out how do determine the path to a given folder with a SQL query for a long time.  Finally I had a project where I really need this ability so I searched online for something similar. 

      Eventually I found this:  Dump list of full paths of parent/child type records in SQL Server 2008 R2

      Which I changed to look like this:

      USE PWDemoMSSQL
      GO
      WITH folder_paths (o_projectno, folder_path)
      AS
      (
      -- Anchor…

      • Tue, Feb 18 2014
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies