No xp_cmdshell allowed in my circumstances.

Could you provide sample code(s) for other feasible and efficient ways.

Thanks.

Guys, thank you for the efforts and I got the solution already.

Thanks again.:satisfied:

You're back. Thank you.

create table dbo.dynamictab(CustID varchar(20),col1 int, col2 int, col3 int, col4 int)

insert into dbo.dynamictab values('aa',10,20,30,40)

insert into dbo.dynamictab values('aa',20,30,40,50)

insert into dbo.dynamictab values('aa',30,40,50,60)

insert into dbo.dynamictab values('bb',40,50,60,70)

declare @sql_1 nvarchar(max)

declare @sql_2 nvarchar(max)

declare...

Either 'huh' or 'hug', both have the same meaning to me. I got it. Thanks to ALL of you !:Whistling:

Thank you for your patience, and I'm back .....

The following example has two sp_executesql(s) which I got the result of the first one passing to the second one. First...

Thank you anyway, but I am still here waiting to receive more response(s).....

:Wow:Thank you.

I am greedy and I want both.

First for the project I am working and second for digging and learning more for the future.

Salute.

First, THANK YOU a lot guys for the extreme support.

The code I quoted is just one tenth of the original program.

My purpose is very straight forward and the database I...

Thank you for response again and I do understand.

If you do not mind, could you please show me how to do it IF using my "string1" instead of getting from...

Thanks for the response.

But I got all "FirstName" string for the result instead of getting the real content of "FirstName" column.

Yes, Sir I got it.

Thanks.

Thank you for the solution.

Is it possible to have an "UNPIVOT" alternate ?!

OK! Thanks for the info!:-)

First thanks to all! I have the background of Java, C/C++, VB. The only concern is whether the two stars - VB.NET and C# can be both used...

Any ideas where is the language of the "report" ? Thanks.