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') '.