I have had a Honda Civic Hybrid for 4 or 5 years now. I'm not a car person, but for the first time in my life, I'm excited about...

tymberwyld: Thank you for taking the time to reply. So much to think about....

David: Thanks again for your reply. You did a good job of laying out a decision framework / set of criteria to use for making these kinds of...

David: I've been thinking more about your reply. Particularly, I've been caught on your first sentence: "Aren't you just normalizing the question type out of the client-question-response?"

That's such...

David: Thanks for your reply!

To answer one of your questions, "Would you look for clients by their responses across survey's?" - At the moment, I don't see that happening...

Thanks for the article. I'm interested in understanding different design schemes. My question may have already been answered, but I'm not sure.

For the first time, I'm considering an...

Dave: Thanks for the feedback!

I appreciate the article for it's nice high-level summary of issues to consider combined with easy to understand, detailed examples.

I have one suggestion/question/tweak. This is not a criticism, just...

Thanks for the additional reply. I wish there was an easy escape character or set of characters to say "hey, please print this text as-shown". Sort of like...

Matt: Great tip! I used it on my earlier post and it worked. Thanks.

Mike: Thanks for looking into it. Glad to know I didn't miss something terribly obvious.

re: "replace required on certain characters. "

I would add: & # x 0 D ;...

Mike: I'd be interested to know if you ever get the TYPE option to work. I had read about it and tried it, but it never worked for me....

Matt: I've run into that very problem on more than one occasion. Sometimes I do a replace() to fix the problem. Sometimes I can change the text...

Like others, I love CTEs and use them a lot as an alternative to derived tables. As stated, CTEs are great when the dataset is needed more than once...

Jeff,

I love articles like this that do such a good job of explaining things step by step. I particularly appreciate the real-life example by taking...