Thanks Michael.

Your ideas about the Answer_Text table makes sense.

Of course, I will change the name.

The only clarification I would need, if you don't mind is that since I have 6...

First of all, thanks for your response/

Well, I didn't think that Questions table is bad.

How about SurveyQuestions with the attributes that I indicated/

Then SurveyChoices with the attributes I listed.

Finally, SurveyAnswers...

Hi Lowell, yes, I do have a separate table that tracks emails called Notifications.

Each time a reminder is sent, a field called Sent is updated from No to Yes.

This...

Since you don't have a support agreement, I would do whatever I wanted.

I think this is a lousy, albeit, silly assumption on your part. Forgive me for being blunt.

The...

Hi Jeff,

Yes, I did but since we don't have a support agreement with them, they are asked us what we tried and we told them the trigger I posted here...

We have a vendor app that can't be modified.

However, we are allowed to manipulated what they call custom fields.

These custom fields are literally called field1, field2... up to filed5.

Right now,...

Hi Lynn,

Thank you so much for your responses.

I must say though that I am very confused with your questions.

You asked if table1 is related to table2 by userid?

I did say...

You are a life saver extraordinaire.

Thanks for your code, your explanations and patience.

It is working a like a dream!

There is 0 chance that position id is null or 0.

Thanks a...

Thanks Jeff,

My fault. My reasoning was that our production server hosts sql server 2008.

So, I figured it is better to have a sql server 2008 solution than 2005 because worst...

Hi Jeff,

Thanks so much for your help sir.

Yes, you are right; I should know better - sorry about that.

I am trying to test your code but keep getting errors.

First I...

Thanks a lot for your response but this is not a reporting app.

Hi Jeff,

Thanks a lot for your reply to my thread. It is much appreciated.

No, I don't have any issues whatsoever with your comments or recommendations even if it is an...

Thanks for the great advice Sean!

Thanks Jeff.

thanks alot Adi.

That worked.