quey conversion from oracle to sqlserver?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ravi - 19 Apr 2008 11:00 GMT

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.

Reply to this Message

bruce barker - 19 Apr 2008 23:44 GMT

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)

> hi friends,
> The below given query is work on oracle.Help me out write same query
[quoted text clipped - 16 lines]
>
> 10 rows selected.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...