Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.

SQL Server >

SQL Server Forums >

SQL Server Data Warehousing >

Oracle to SQL Query

Oracle to SQL Query

Friday, January 18, 2013 6:24 AM

0

Hi All,

I am having trouble in converting the oracle query to SQL query.

select distinct d.subtype,l.valdate,l.attrtype,d.name,c.catname,d.createdby,d.createdate from llattrdata l, dtree d,
catregionmap c where d.dataid in (select dataid from dtree start with dataid in(57103) connect by prior dataid=parentid) and d.dataid=l.id and l.defid=c.catid

Help me on this.....

Regards,

Ravi
- Reply
- Quote

All Replies

Friday, January 18, 2013 1:35 PM

0
I guess your problem is the "Connect by Prior" statement which is not available in T-SQL. This in SQL Server can be achieved with recursive CTE suing the "WITH" statement.

For more check here: The equivalent of Oracle CONNECT BY PRIOR in SQL Server
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, January 24, 2013 1:56 AM
- Reply
- Quote

Frequently asked questions - Forums help