Forum: MS SQL Dec 30th, 2008 |
| Replies: 7 Views: 834 WOW This is great... I can work with this. I've put the syntax into SQL Query Analyzer and ran it. It stops on Line 9 "CREATE PROC GetAllParent". But I can work with this. With the article you... |
Forum: MS SQL Dec 29th, 2008 |
| Replies: 7 Views: 834 I've thought about that. The biggest problem with it is that some of the path could be 8 to 10 parents deep. There is no way of knowing. I thought about a loop and just loop until o_parentno = 0 but... |
Forum: MS SQL Dec 29th, 2008 |
| Replies: 7 Views: 834 Greeting
When it comes to SQL I'm a novice and I think what I want to do is WAY outside my expertise. I have a file management system called ProjectWise. Everything to create the folder path is... |