Ok, Thanks a bunch man!

This:

SELECT FieldID, FormID, Name INTO Temp1 FROM dbo.FormFields

SElECT EventID, FieldID, UserID, Response INTO Temp1Response FROM dbo.FormFieldResponse

IF EXISTS (SELECT Name

    FROM   sysobjects

    WHERE  Name =...

But that's not gonna work for any FormID number, will it?

Cool,

Thanks man! But is it possible doing it w/o knowing FormID? Can you do it so that it grabs it automatically depending on FormID?

Or maybe it's easier to output it...

Well we are planning eventually doing that.

If I shrink DB to like 20-30 Forms with 20-30 FormIDs - can dynamic sql handle that?

If so can you help me make it...

Yes, exactly, I want to return data across all FormIDs.

Thanks so much for your help man. I know it's a lot.

It would be nice if you can tell me where/how to integrate it into that script from T-SQL section.

I needed to list something like:

| EventID

|  1        |  <-

|  2        |  <-

|  3        |  <-

|  4        |  <-

|  5        |  <-

I know approach is terrible - someone wrote the code...

Ok,

I understand. Sorry I paste code with missing parts... that's not the point though.

I need to output table with all FormIDs - we have over 300 of them. I just...

It's a big one in T-SQL section =)

I meant dynamic like - all the data changes all the time. Records, amount of fields and etc.

Well, that's what I did with it to get all the proper data...

Well,

I need to put values of EventID into a comma-separated string. Then split() and declare as new variable.

Then it will be passed to a procedure.

Thank you so much for responding.

This is great help.

I understand everything, except how can I make it work with dynamic sql tables? I mean 2 original tables in SQL are...

Here is the image of a final result:

Sorry it didn't work last time.

People talk about pivot - but i have no clue how to do...

Relationship is: Table 1 has Column "Name" - that's name for each field on Dynamic Form(already have written dynamic form upload) which can be textarea, and other inputs.

Now "Response" on...