You missed the part about the sample data (last third of the page).

Was sarcastic .

Is this supposed to be funny??

Now that could be arranged. Btw I don't eat desserts and I'm 20 years too old for Spongebob... looks like you have no leverage on my dad

Expecting to be stuck again??? .

SET @SqlString = 'SELECT EventID, B.UserID, LastName, FirstName, Organization, FormID, ' + @SqlString + '

FROM Temp1 A

JOIN Temp1Response B on A.fieldId = b.FieldID

JOIN UserInfo C on B.UserID = C.UserID

b or...

That's why you have question and he doesn't... That's a fact too.

BTW stop acting like a baby... those reports aren't done yet .

We can't help you without sample data.

What results are you getting from this query. What results should you be getting?

Same thing at the end of the query. I'll stick to my guns on this one.

BTW you're exactly like frank except for his tsql knowledge

Both . Especially the third one.

The code to execute the sp one time will be :

Exec dbo.SpName Param1, param2, param3

Now you just have to concatenate that for each line you need to add skills....

The table variable was simply for demo purpuses .

I can't use this I want the insert statement, do you expect me to retype all this just to help you??

Check this out there's a insert generator link in there...

You're exactly like him... always need to have the last word.

As seen by your post count you too have understood this.. maybe you'll be at 500 by the end of...

Not exactly. I'd probabely record all the sp calls in a string, then execute the string. I'll save a lot of network traffic that way.