| Author |
Topic |
|
Gmaboing
Starting Member
7 Posts |
 Posted - 2010-04-02 : 11:08:12
|
| posted my exact question to another board and got results within 4 mins |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 11:11:47
|
| are you using sql 2005? how is data stored in your table? is it a self mapped table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 11:17:23
|
quote:
Originally posted by Gmaboing
Visakh16, I am running 2005.not sure what you mean by how it's stored in the table and if it's self mapped----------------------I am a undercover nerd and I can solve one side of a Rubik's Cube.
how is hierarchy represented in table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-02 : 11:29:37
|
| I think what is being asked for is the table structure that the hierarchy is stored in.But, if you know how to query the table to get the hierarchy, you can use the ROW_NUMBER function to get distinct paths or you can use a GROUP BY clause. |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-02 : 12:23:54
|
Incase you missed this part in my response:quote:
Originally posted by Lamprey
I think what is being asked for is the table structure that the hierarchy is stored in.
Also:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-02 : 12:33:24
|
| Understandable. That's why I posted the link above. That'll help you to post the table structure so we can help you better. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 12:36:27
|
quote:
Originally posted by Gmaboing
i didn't miss it, i don't know what you mean by this. i am new to sql and this is all greek to me. i can muddle my way through pulling the data but when you start talking about table structure and hierarchy that's when you loose me----------------------I am a undercover nerd and I can solve one side of a Rubik's Cube.
what we're asking is give you table information (column details with sample data)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 12:44:54
|
quote:
Originally posted by Gmaboing
.
why did you do it? Do you think it was a good thing to do?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-02 : 12:46:13
|
quote:
Originally posted by Gmaboing
posted my exact question to another board and got results within 4 mins
so removed entire question from there as well? Dont you really think sharing the solution will benefit others?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-02 : 15:59:16
|
| What site was it? Sounds like a sweet site! |
|
|
|
|
nevermind