• andy.dawson (11/13/2007)


    I might have to bail out on this one! 🙁

    Even if this did exactly what I wanted, I wouldn't be able to administer it because I just 'don't get it' (yet).

    I reckon MS Access is more my level at the moment.

    Thanks all for your help though, it's much appreciated.

    Andy, I would hate to see you give up that easily. And remember this; anything you can do in Access you can do in SQL Server and then some. The code I posted comes from Books Online, and is a way to expand a heirarchy. The code within the code block will create the procedure and store it as an object on your server, just like you would create a query in Access. The execute statement will produce the *exact* results you specified. The only catch is that you need to have permissions to create a procedure. Its just like Access. You can also use Access as a front end to SQL Server. I have plenty of forms that do just as you need to do. You enter in your parameter, hit a button, and voila, your lines appear. If you do decide you are going to do your entire project in Access, I would suggest AccessMonster.com as your best resource. If you are going to use an Access ADP(specifically made for use with SQL Server, and what I use) you can go to

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access.adp.sqlserver&cat=en_US_fcdda3c1-4861-428d-be18-b0d9a39f74b7&lang=en&cr=US

    Now, you said you just don't get it(yet)...me neither buddy, but thanks to your post I now know what a heirarchy is. The great thing about forums like this are that there are plenty of folks who will stick with you until your issue is resolved. This one in particular is a little over my head too, but not for the main contributors here. Two years ago I could not even spell Access. I did not even know what SQL or a database was. Thanks to these fine folks I can keep my head above water at least. Anyhow, good luck.

    Greg

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.