Probably not more than 35

FBP

Not more than 30 I think

Thanks,

Looking forward to your reply

FBP

Robert,

It does not work, as depending on the IDSurvey, the Questions table may have different number of questions, so the pivot column "Question" has to be built dynamic.

Thanks anyway

John

Two related tables, Questions and Answers:

Table Questions:

 [IDQuestion] [int] IDENTITY (4125, 1) NOT NULL ,

 [IDSurvey] [int] NOT NULL ,

 [Question] [nvarchar] (800) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [NPage] [int] NOT NULL ,

 [Order] [int]...

John,

Sory but what do you mean by DDL?

FBP