![]() I did this because I need to upgrade SQL Server from 2014 to 2016 to match our production environment. I just upgraded my PC from Windows 7 to Windows 10. WHERE MYFOLDER_Id = MYFOLDER_LogicalName + '\' + = MYFOLDER_ParentID Select = min(MYFOLDER_Id), = max(MYFOLDER_Id)ĪND <= MYFOLDER_ParentID = MYFOLDER_LogicalName = #FolderTemp The application has been neglected for a while but we are now finally trying to retire it, which is why I'm trying to get this folder structure information. ![]() And yes, just to confirm, the back-end is SQL 2000. The function given in that post works and I've tried to reverse-engineer it to return results for all rows, but I'm clearly in over my head as I get no results. My use case is very similar to the one in this old post, except I need to be able to return the folder path information for all rows in my table, which is fairly small (727 records). We have an old database application with a table that represents folder structure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |