I am making a folder cabinet table where the user can add up to 30 levels of folders
The table structure looks like the attached.
If my next record was a child of folderID 3. I would need the folderIDPath to equal 23.03.04 (4 would be the identity key of the new record going in)
erID with leading zeros for ParentId/FolderID
Anyone have any idea how I can write this in SQL Server?