Hierarchical Query

[Manohar]

Hi All,


We have CONNNECT BY PRIOR and STARTS WITH commands in ORACLE to query for a hierarchical data..

In MS SQL we don't have any such commands. So how can we achieve this in SQL? If it through stored procedures pls let me know how we can do this in Stored procedures...

Also pls let me know how to combine results sets of two diffrent select statements that returns same type and number of columns....

Any help is greatly appreciated.

TIA

Rgds
Manohar

[Simon Sellick]

Hi Manohar,

Microsoft give an example of expanding a hierarchy in their books on-line
included with SQL Server 8. If you have it installed, this link should find
the example:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acdata.chm::/ac_8_qd_14_5yk3.htm

To combine two similarly-shaped query results, use UNION or UNION ALL, e.g.

SELECT a, b FROM c
UNION
SELECT d, e FROM f

Hope this helps,
Simon Sellick.

Manohar <manu2679@yahoo.co.uk> wrote:
>Hi All,
>
>
> We have CONNNECT BY PRIOR and STARTS WITH commands in ORACLE to query
for a hierarchical
>data..
>
>In MS SQL we don't have any such commands. So how can we achieve this in
SQL? If it
>through stored procedures pls let me know how we can do this in Stored procedures...
>
>
>Also pls let me know how to combine results sets of two diffrent select
statements that
>returns same type and number of columns....
>
>Any help is greatly appreciated.
>
>TIA
>
>Rgds
>Manohar