Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Get tables list based on Parent/Child relation

    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...

  • RE: Child and parent Relation

    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...

Viewing 2 posts - 1 through 2 (of 2 total)