Unanswered: converting from Oracle to MS SQL Server 2000
I have this Oracle Sql statement but I need to convert it to SQL Server Statement.
"SELECT LPAD('-', 2*(LEVEL-1),'-') || DESCRIPTION DESCRIPTION, LEVEL_CODE
START WITH PARENT_CODE = 0"SQLStr=SQLStr&"
CONNECT BY PRIOR LEVEL_CODE=PARENT_CODE "
Sql Server gives Run time error message which is about LPAD is not recognized etc...
Also does anybody know a tool that converts Oracle Sql statements to SQL Server Statement?