Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by luk4u
-
performance probs ..anyway please help
Hi All Please let me know anyway I can get around in writing this type of query in analysis manager mdx expression it is taking longtime to load and edit. Filter ({GENERATE({[x_DIM].[All x_DIM].CHILDREN},{TopCount({[AC_DIM].[empno].members}* {[x_DIM].[All x_DIM].CHILDREN}, 25, ([Measures].[...- luk4u
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
oracle cursor convert into sql server coding
DECLARE v_counter NUMBER := 1; BEGIN FOR i IN (SELECT DISTINCT empno FROM emp) LOOP FOR i IN (SELECT DISTINCT deptno FROM emp > WHERE empno = i.empno) LOOP FOR k IN (SELECT amt FROM emp...- luk4u
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
