Unanswered: Migrate Oracle "Connect By" clause to TSQL
Since this is my first post, if there are any violations in the rules of the forum, please let me know so that I can correct myself from next time.
I am currently working on migrating some oracle stored procedures to TSQL. One of the stored procedures uses "Connect By" clause in a select query, provided by Oracle. Is there a standard way to migrate this clause when we migrate this to SQL Server TSQL Stored Procedure.
I have a query in the oracle stored proc like:
SELECT id FROM t1 START WITH t1.id = p_id CONNECT BY
PRIOR t1.id = t1.parent_p_id
where p_id is an IN parameter passed to the stored procedure.
Please note that I have assumed "Connect By" clause syntax and usage is known to anyone who replies for this post.