Hello All,

I would like learn Hierarchies in "SQL". I do have the Transact-SQL Cookbook
by Jonathan Gennick.

Are there any other book that talks about this topic that I should read.
Also, if anyone can point to some
links that would be great as well.

Thanks,
Gopi

TREES & HIERARCHIES IN SQL  by Joe Celko

Not to toot Joe's horn, but that is an awesome book!!!

Check out SQL for Smarties by Joe Celko as well.

Great stuff.


Rick Sawtell
MCT, MCSD, MCDBA

Shame he's so rude to people in real life. I'd love to have a look at his
books as they seem so raved about but I don't think I could bring myself to
buy something from someone who's so needlessly rude to so many people.

Wrong.  I am a pussy cat in  person.  I have a deliberately advosar

Wrong.  I am a pussy cat in person.  I have a deliberately adversarial
newsgroup personality.  After ten or so years, you get tired whining
"do my homework/job for me", or "give me a kludge so I can kill
people" postings.

The first group of whiners is why Chris Date does not answer email
address.  I turn them into their schools and have them expelled for
academic cheating (2 and maybe 3 so far)

The second group is more of a problem.  In 2004, it was kid who threw
out 1NF on a medical supply system for African relief.  He was more
bothered by the fact that I was rude to him than that his incompetent
was killing children in a war zone.

Grow up.  See a few episodes of HOUSE.  Then get professional.

Well that's fine, but some people are coming on here to develop and learn
from other people, your style puts people off. You don't come across as a
friendly and helpful character. (and presumably you must be at heart if you
like looking into people's sql problems and solving them for free) Oh I
dunno, maybe I'm too patient with people myself... anyway self perception
analysis is a bit off topic so I'll shut up.

Procedure parameter
Help! Two-Part SQL Update
Just venting
os_oa* run exe written in vb6
Foreign key help
Trigger help followup.
Join Efficieny
Save BLOB to SQL2K TEXT column in VB.NET
Execute SP if returns data
RESULTSET PROBLEM