I think it is not possible to get that window again.

I don't know who you are but I still removed the post !

You cannot claim that you are the one who really framed the question !! Where...

Appreciate your response -  Mike01, 

I agree with you Jeff. I wish I could do that. Lol....

Thanks Jeff for the idea. I actually implemented the same idea you said. I penned down all the stuff in the papers. I got the same idea so now I...

The Execute DDL tasks fails and I get the error message like this:

[Analysis Services Execute DDL Task] Error: The System.__ComObject text node at line 7, column 34 cannot appear...

For Example.

Refer the figure.

Considering First Hierarchy tree:

[Dim Marketing Product].[Product Version].[Product Version] as "France Term Life + Assistance"

[Dim Marketing Campaign].[Campaigns].[Campaign Country] as "France"

[Dim Marketing Campaign].[Campaign Market].[Campaign Market]...

Thanks Dwain. I will try your idea too... but for the need of the hour -- resolved it with while loop...

DECLARE @RESULT TABLE

(

ID INT IDENTITY(1,1),

ACT_TYPE varchar(100),

LIST varchar(8000),

START_DAT datetime,

ACT_UP_DAT datetime,

ACT_AUTO int

)

INSERT...

Thanks Gila. Done that all ready ....

Thanks, but the error was different - It had multiple GO and removed the GO commands. Its working now........

Thanks all. It is working...

Hi Lutz,

I had used the Split function that you referred in the signature...

Here is that code, I am using...

CREATE FUNCTION [dbo].[DelimitedSplit8K]

--===== Define I/O parameters

...

Hi Lutz

DECLARE @tbl TABLE

(

id INT IDENTITY(1,1),

list VARCHAR (200)

)

INSERT INTO @tbl

SELECT '47,48,49,92,93,94,95,96,108,107' UNION ALL

SELECT '37,27';

WITH cte AS

(

SELECT id, item

FROM @tbl

CROSS APPLY

(

SELECT...

Please find the core I executed...

DECLARE @tbl TABLE

(

id INT IDENTITY(1,1),

list VARCHAR (200)

)

INSERT INTO @tbl

SELECT '47,48,49,92,93,94,95,96,108,107' UNION ALL

SELECT '37,27';

WITH cte AS

(

SELECT id, list

FROM ...