Yep, It just returns records from the Field, table join the FieldResponse table, Does not care what formID is there.

If you need to know the formID in the output, then...

There's no easy to do it that way.

But this gets you the same thing.

Create Table Temp1 (FieldID int identity, FormID int, FName varchar(50))

-- Test Fields

Insert into Temp1 (FormID, Fname)

values (233,...

For all things that are null, err not null, ergo Unknown.

read todays article

http://www.sqlservercentral.com/columnists/mcoles/fourrulesfornulls.asp

You should be able to get it to work with 20-30 formID;s

It just depends how big the names in the field table are.

-- First need a function to parse a...

Well unfortunatelly the solution I gave you works well by formid, but using dynamic sql there are limitations, because the number of columns for each form id and the number...

I don't understand what you mean. The code I gave you allows you to return data by formID, You want to return data across more than 1 formid?

Please Post some...

Goober, You have syntactical errors when trying to execute the stored procedure.

ReturnResponseByEventXML requires a formID, and an Event ID, you have provided 233 as the Formid, but what is the...

From Books Online.

Rtfm (Read the Manual)

"Column statistics for the query optimizer are not available."

"As the data in a column changes, index and column statistics can become out-of-date and cause the...

I don't know what you mean by dynamic tables?

This should work with the tables you use.

-- When your creating the Crosstab query string, Replace your tables here

SELECT @SqlString =...

Okay you have way too much going on here, You have a table that contains fields for virtual tables, then you have another table that has values for those virtual...

Yay, you finally posted what you wanted your output to look like.

You definatelly do not need a cursor to pivot data.

Pivot data TUT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_04j7.asp

Create table CallHistory (pk int identity, AccountID...

May not necessarily apply to question listed, but to dynamically number rows, you can do self join.

Reference,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133

Good examples

Image is a broken link.

I think I get the relationships

You want the recordset output as xml?

Since your table schema, (Or lack of schema) is structured this way it would...

Certainly you should be able to do that without using a cursor.

Can you post a test table with some sample data, and show an example how you want the results...

Almost.

What is the relationship between table 1 and table 2?

The xml asside, would you say the value for FieldID 7227 is in Table B many times for different EventID's?

You want...