Person types in something in textfield, then it's passed into procedure that builds table and it would output only fields with values he entered.

The problem was solved by adding set @EventID = @EventID + ',0'

and adding LEFT JOIN on UserInfo.

Now it works, but it gives back multiple identical Responses rows.

The sam thing

Ray, I sent you PM.

you mean this exec sp_executeSql @SqlString, N'@FieldID varchar(500), @EventID varchar(500)', @FieldID, @EventID

to

exec(sp_executeSql @SqlString, N'@FieldID varchar(500), @EventID varchar(500)', @FieldID, @EventID) ???

I do use QA  - but it's not it. I changed max lengths - still the same.

I was thinking though it was @sqlstring nvarchar(4000)

So as someone said I changed it...

Ok, it was working fine until i actually implemented it into the website. U cut out the way it gets values, but here is the main FINAL procedure:

CREATE PROCEDURE dbo.ReturnResponseByFormSXML

(

 @EventID...

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 = N'ReturnResponseByFormSXML2'

    AND    type...

Now eventID also gives the same error....

i tried that - still the same syntax error.

tried @fieldid as int and varchar - won't help.

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 = N'ReturnResponseByFormSXML2'

    AND    type...

I know I know =)

I just realized to late, when you posted this yesterday already =)

UserID will do through VB.

I want it to query through FieldID and EvenID actually.

So it would be like this, right?

-- Uzaem Dynamic Sql chtobi sozdat stroku dlya execute.

-- Sozdaem Pivot...

Cool, that worked. I just had to specify FieldID with 'B' in SELECT and GROUP BY clause so that procedure knows which FieldID we are using.

Now when I try to...

Ok =)

Here is another question.

I have another table "UserInfo". Which has "LastName", "FirstName" and "Organization". They all associated with "UserID" - that table has it as well.

Is there a way...

Ok, it works =))) Thank you sooooooo much man!

I'll prolly will have another small question later on today