Thank you so much for your sample code and looking into it.

What I am looking to do is not to change the Table Valued Parameter every time. With your example,...

Lowell,

The problem with this approach is, I need to modify the .NET code every time if there is control retired or add a new control. I don't want to do...

Yes, we don't want this to be static and define all 400 parameters in a stored procedure.

And there is every chance, we add column #401 in future. So this is...

Million dollar question: Is there a requirement to avoid application code changes when you add column #401 to your table?

Per this article a stored procedure can have up to 2,100...

Thanks for your replies....

OK, Here is my requirement. I have a table with 400 columns. We have customized templates for different scenarios. So in each template, I may display some...

SSCrazy,

Thanks for your reply and comments. I totally agree with you on the future maintenance. But for me there is no other way of doing this requirement. Believe it or...

Lutz,

Thanks for your response. My columns would be dynamic. Here is a scenario..

-- The following temp table is similar to my Table Valued Parameter.

CREATE TABLE #Test (ColumnName VARCHAR(100), ColumnValue VARCHAR(100),...