Post reply

Get tables list based on Parent/Child relation

  • October 22, 2009 at 4:34 am

    #227290

    Is there a way to list (using SQL server 2005) to list hierarchy of

    table parent & child relationship:

    1) A list that shows which table should be deleted first,second,third...

    2) A list that shows which table should loaded first, second,third...

    Thanks.

  • October 22, 2009 at 4:43 am

    #1069297

    Try this link

    http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/


    Clear Sky SQL
    My Blog[/url]

  • December 13, 2010 at 6:27 am

    #1261657

    Hi,

    I have two queries, say for example

    Select distinct 0 parent_id, ROW_NUMBER() OVER(

    ORDER BY Column2_Desc ) AS 'ID', Column2_Desc

    From table1

    Union

    Select distinct 0 parent_id, ROW_NUMBER() OVER(

    ORDER BY Column2_Desc ) AS 'ID', Column2_Desc

    From table2

    I don’t have relationship between two tables.But I want to frame parent child relationship between these two so that my resultset should like

    Parent_ididColumn2_Desc

    01ABC

    02XYZ

    03ASDF

    14VGTY

    25DFT

    I don’t want to use stored procedure.

    Kindly Help Me Out

  • December 13, 2010 at 7:46 am

    #1261707

    Im not clear on your issue , but in any case i would start a new thread. Most people will ignore old threads.


    Clear Sky SQL
    My Blog[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply