use of cross apply - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

use of cross apply

Author

Topic

senpoly
Starting Member

19 Posts

Posted - 2007-06-25 : 08:35:19

dear friends
i am using cross apply

in my stored procedure which is running in a database
the code is as follows

SELECT *
FROM gimdomcontainers AS D
CROSS APPLY cntrtop7(d.containerno,2,d.activitydate) AS ST

it runs fine but while i copy this to another database it shows error as

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.

i am confused so can any body help me in this regard

regards
senthilkumar

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-25 : 08:42:47

Is the another database running on SQL Server 2005?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

senpoly
Starting Member

19 Posts

Posted - 2007-06-25 : 09:09:21

yes another database in same sql server 2005

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-25 : 11:01:39

And the function cntrtop7 is present in the new/other database?

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-25 : 11:05:38

And the compatibility level of the new/other database?

KH
[spoiler]Time is always against us[/spoiler]

senpoly
Starting Member

19 Posts

Posted - 2007-06-26 : 05:09:24

thank u khtan
i have checked with the compatibility, that was the probelm actually
i have changed the combatibility to 90 and its working fine

Saravanan
Starting Member

1 Post

Posted - 2007-07-13 : 11:37:21

Hi Harsh,
We are migrating all the procedures from SQL Server to Oracle. In SQL Server 2005, Cross Apply has been used. Can you please tell me what is the equivalent for Cross Apply in Oracle 10G?

quote:
Originally posted by harsh_athalye

Is the another database running on SQL Server 2005?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-13 : 12:11:54

Please post your problem in dbforums.com since it is not a Microsoft SQL Server 2005 issue.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources