I am not able to make out anything of this. You have a table CSDAT, which appears to have the columns MeasureName, Question, Client Valied, Score, Positive and Responsecodes. And what do you want to do with them?
For this type of question, you help yourself enormously if you post:
1) CREATE TABLE statement for your table(s), preferrably simplified for the problem at the question.
2) INSERT statement with sample data.
3) The desired output given the sample data.
4) A short description of the business rules that explains why want that particular result.
5) Which version of SQL Server you are using.
It is possible that if I stare at your post for half an hour or so, I would get what you are looking for, but keep in mind that people who answer here, are spending their free time. So if you are only making a half-hearted attempt to explain your problem, you will only get half-hearted attempts to answer back.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment