What is really missing here is database design.

Was it like this

/* comment

/* machine comment*/

*/

?

If that's a case I would suggest to get familiar with the syntax of the programming language before trying to use it.

BTW, it's not about only TSQL, it's about any...

I'm puzzled as well.

What's wrong with your resultset from Lookup_tbl?

What did you expect?

IF inside of SQL statement?

Or it's just dynamic WHERE clause?

Should we open permanrnt classes how to avoid dynamic WHERE clauses or how to work it out when it's unavoidable?

And if there is a transaction you may deadlock it forever.

I would suggest to get rid of the cursor and get it finished before progress bar can appear.

Can anybody explain what's a point of dynamic SQL here?

I would not think somebody could come to an idea to create the latest version of SP if it does not exist and leave whatever thing was written I don't...

My "dynamic" does not have any quotes.

It always as simple as 'CREATE PROCEDURE xxx as select 1 as One'

Than the real scrpt goes, but it's included into ALTER statement....

if not exists (select * from dbo.sysobjects where id = object_id(N'xxx') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

EXEC ('CREATE PROCEDURE xxx as select 1 as One')

GO

Alter PROCEDURE XXX

AS

...

What datatype you plan to use for columns in rotated table?

Do you call SP from BizTalk?

I have restriction in my current project - no more than 2 sec. respond for summary query on 2 mil. rows.

Currently I keep it within 0.5 sec.

Just for you to...

Author swore he has read only access...

If he cannot create table he cannot create function as well.

Run this:

SELECT Id, count(*)

FROM report_layout

GROUP BY Id

HAVING COUNT(*) > 1

It will show you how bad is you situation with duplicate key.