Hi Balaji

I am facing a similar issue......may i know how you split the XML file into tables using SSIS.

Thanks in advance

Itz

Hi

The end users either want to provide a value manually or they might select multiple values from multi-valued parameter.

Its all about the requirement dude....:-)

Thanks

Hi William

Thanks for your response.

It looks, its a bit complicated issue and not in the scope of SSRS. May be we can do it using .net but not sure how.:-)

As...

No, I am querying a SQL Server 2005 Database, not SSAS cube.

Thanks

Your suggestions were really helpful. I fixed the problem.

Thank you Dan and Siddhu.

ItzMe

Hi Chirag

Thanks for the response!!!

The first procedure you suggested me works fine, but with a bit enhancement.

I have made a full outer join between the tables and made a single...

Can you explain me the method of wrapping up the stored procedure and merging multiple rowsets in a temporary table in detail....

Thanks in Advance

ItzMe

Yes absolutely. Only DDL.

Small Clarification..... Cant we achieve both DML and DDL at the same time.

Regards

Itzme

Useful Information

Thank You !!!

I got a fix for it.

Here is the code.........

DECLARE @sSQL varchar(4000);

SET @sSQL = '

UPDATE [MyDB].[dbo].[Report_Measures]

...

Hi Friends

I got the solution for the topic i posted.

Here is the way i did.............

declare @a xml

declare @b-2 xml

declare @C xml

set @a...

Hi Lowell

I have an xml file as source............which is called into a stored procedure.

I need to execute the stored procedure for every row of xml using sql/xml concept.

I could not...

I need to use SQL/XML to execute a stored procedure for each row of xml.

How is SQL/XML used in SSMS.

Regards

ItzSam

Yeah Chris....I agree with you.....

I cant disable the trigger as of now.....but can alter the table DDlog.

Even i learned a lot today from all you guys........really grateful to you.

Its just...

Sorry for the delayed reply....was away for sometime

when i executer sp_help ddlog

this is part of what it has to say.....

DDLEventIDuniqueidentifierno16 yes(n/a)(n/a)NULL

DDLEventnvarcharno200...