Many many thanks Antonio. Your XML solution gets me the expected result. I'd also like to thank GSquard and Jeff for their contribution.

-Lalon

Hi Jeff,

Your code works fine as per my original request. There is an error on my part on the requirement, I apolozise. Apparently, there are Rows that are...

Jeff,

The Parameter is coming from the .RDL file SSRS 2005. All the parameters from the .rdl file logged into this field. Thanks I'll work on it in the...

Jeff,

I'm NOT loading this into a table. I'm reporting on the executionLog table in reportserver database. I'll be quering the table to CREATE a DATASET in that format....

Wow! I don't know where to start. Thanks for taking the time. Actually this is one of the field in a table. It's from the [reportserver].[ExecutionLog...

I should have this in a command type text or as an expression?? You have a "=". By the way the I have named list in the SELECT...I...

="SELECT * FROM Employees; EXEC dbo.insert_into_table_Sprocs @parameter=" & Parameters!XXX.Value

Marios answer is what I'm trying to do. I'll give it a try. SELECT is returning the dataset for my...