Paul Giesenhagen
QuillDesign
----- Original Message -----
From: Ben Shichman
To: CF-Jobs-Talk
Sent: Wednesday, July 28, 2004 11:02 AM
Subject: Re: SQL Pricing
This is pretty straight forward - check out Joe Celko's nested
set model:
http://groups.google.com/groups?q=Joe+Celko+nested+set&hl=en&lr=&ie=UTF-8&selm=Oy21PVU6AHA.1380%40tkmsftngp05&rnum=1
The model is covered in depth in his book "SQL for Smarties"...
Good luck!
--- Paul Giesenhagen <[EMAIL PROTECTED]> wrote:
> I need someone who is good with SQL to pass over some queries.
>
> It is for a tree/hierarchy possibily nested set or adjacency
> model.
>
> example output:
>
> mens/
> mens/shirts
> mens/shirts/tshirts
> womens/
> womens/shirts/
> womens/shirts/tanktops
>
> OR ID Values
>
> 1/
> 1/3
> 1/3/5
> 2/
> 2/4
> 2/4/6
>
> I need the table structure, select/insert/update/delete and a
> query to take the bottom value (ie tanktops) and find the path
> back to the top /womens/shirts/tanktops/).
>
> I am looking for someone who can provide a $ amount for this
> that can write this for MSSQL / MySQL and hopefully Access.
>
> My thought is there is already queries for this and if you
> have them and would like to share for a few $$, I would
> greatly appreciate it.
>
> Paul Giesenhagen
> QuillDesign
> 417-885-1375
> http://www.quilldesign.com
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
