quey conversion from oracle to sqlserver?

[ravi]

hi friends,
The below given query is work on oracle.Help me out write same query
on sqlserve i want the same resule.
select * from (select trunc(sysdate) + level from dual
2 connect by level <= 10);

TRUNC(SYS
---------
28-OCT-06
29-OCT-06
30-OCT-06
31-OCT-06
01-NOV-06
02-NOV-06
03-NOV-06
04-NOV-06
05-NOV-06
06-NOV-06

10 rows selected.

 

[bruce barker]

you need to use the ansi sql syntax, rather then orcale's. in ansi sql
you use common table expressions (CTE) and union all to perform
hierarchical joins. the docs have examples

-- bruce (sqlwork.com)