quey conversion from oracle to sqlserver?

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.

Re: quey conversion from oracle to sqlserver?

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)




ravi wrote:
> 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.