Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-04 : 08:37:37
|
| Nilesh Ramesh Sawant writes "Hi,I've a praticular situation. Here it is.I've one table with following definition.FieldIDFieldNameParentIDParentID=FieldID in case of child record.Now the problem is, I need to show all the FieldName is FieldID ascending Order for a particular FieldName.ie.Table -FieldID FieldName ParentID 1 A 0 2 B 0 3 C 2 4 D 3 5 E 4Now I need out put for search on "E" as followingVIEW -FieldID FieldName ParentID 2 B 0 3 C 2 4 D 3 5 E 4I'm unable to do anything in last 8 hours. Could you help me?Thank you.Nilesh" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
View tree Of all parents of particular child 