General information
Forum:
Microsoft SQL Server
Title:
Distributed Query in sql 2000
Hi,
This piece of code worked in a stored procedure in SQL 7.0 but
doesnt work in SQL 2000. Could someone help me?
Thanx,
Jamuna
IF @PAGE = "DIR"
set @mdxstring = "
select * from openquery(BTolap,
'select {[fy].[all fy].[" + @fy1 + "]:[" + @fy2 + "] } on columns,
non empty [DIR].members on rows from testcube') ".
The error messages are:
Server: Msg 207, Level 16, State 3, Procedure SP_test, Line 20
Invalid column name 'DIR'.
Server: Msg 207, Level 16, State 1, Procedure SP_test, Line 21
Invalid column name '
select * from openquery(BTolap,
'select {[fy].[all fy].['.
Server: Msg 207, Level 16, State 1, Procedure SP_test, Line 21
Invalid column name ']:['.
Server: Msg 207, Level 16, State 1, Procedure SP_test, Line 21
Invalid column name '] } on columns,
non empty [DIR].members on rows from testcube') '.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only