[dba-SQLServer] dba-SQLServer Digest, Vol 48, Issue 12

Ok, all this echoing of the same post over and over is annoying!

John,
It sounds like you're helping the scum of the earth--spammers (snailspammers
are spammers too).  But I'll help you anyway and hope you find better work.

You just need to generalize your surveys:
SurveyDef:
	SurveyDefID int
	Question varchar(50)
	QuestionType varchar(10)   (multiple choice, fill-in, choose one,
etc)

SurveyAnswers:
	SurveyDefID int
	SpamTargetID int
	Answer2 varchar(10) 

And then for the "count order", you just have rows in another table
specifying the data needed to build the query.  You only need a few tables
in total.

Greg Worthey
Worthey Solutions
www.worthey.com