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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2007-02-14 : 16:33:59
|
| Hi I have a table Like ID IsParent ParentID Title1 1 0 Now is the time2 1 0 Yesterday was good too3 0 2 Tomorrow will work but it is late4 0 1 Yes it is5 0 3 Yesterday is history5 0 1 Never never comesI just want to displays the parent record and all child records for that parent. Parents are identified by the Boolean IsParentPlease any one can help me pleaseThnaks krishna |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2007-02-15 : 14:27:30
|
| Hi all,Please any one help meThanksKrishna |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-15 : 14:41:51
|
| It helps if you could provide the layout for the expected output, and the output itself.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Recurrsive