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 2000 Forums  Analysis Services (2000)  how to write subqueries using MDX

Author  Topic  sherin Starting Member 3 Posts Posted - 2006-05-05 : 08:19:51 how to write subqueries in MDX In SQL it would be something like this CREATE PROCEDURE sp_proc @param1 varchar(55) as Select id,name from table1 where id in( SELECT distinct e_id FROM table2 WHERE field=@param1) go HOW TO IMPLEMENT THIS FUNCTIONALITY IN MDX please help. URRRGENT