I've always disliked those types of trick questions, and I've sat often enough on both sides of the table.
"How would you fill a cup of coffee with T-SQL?"
"Get a good job using it, hire an assistant, and tell them to get me one."
"If you were going to hold a parade in our office, what would it be like?"
"Is this place family friendly? If not, Mardi Gras. If so, Mickey Mouse. Either way, I'll be taking a sick day. Not a fan of them."
"If you were a tree, what would you be?"
"Not having this interview."
"Star Wars or Star Trek?"
"Ice Pirates."
I'm more than happy to walk someone through my thought processes if they really want to watch Chaos Theory become a solution. These questions have always simply annoyed me.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA