To write a Sql query

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  August 8, 2008 at 12:05 am

  #196724

  Hi,

  I would like to write a query for following structure table...

  Id Text Parentid

  1xyz NULL

  2pqr NULL

  3abc 1

  4mno 1

  5xxy 3

  6oop 3

  7umn 2

  I want my result like..................

  Parentname child Rank

  xyz abc 1

  abc xyz 2

  Please help me to write for query...

  Regards,

  Sunil..

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  August 8, 2008 at 1:39 am

  #854953

  Posted and answered here: http://www.sqlservercentral.com/Forums/Topic548871-146-1.aspx

  If you cross post, then the answers may be difficult to find for others.

  - Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software