Re: SQL help requested - "linked list"

>> Given one of the ID values (they're unique), I want to select the
IDs
that occur before and after in that particular linked list. In a differnet language I would approach this using a recursive function. Is this possible in SQL? <<

Yes, but very ugly.

1. Use a cursor and travel up and down the list, like a proceudral language
2. Use a nested sets model for trees (google it) and allow only one child per parent node.