Presumably one of the last two options was supposed to be Two and Two, otherwise they are both the same and there's only one answer that has Two for the second query (which meant that I could get it right without having a clue what FMTONLY meant)
Thanks for the question. Now you only have to put the semicolon not on a new line, before I go insane 🙂
You must really hate reading my code examples.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not." Helpful Links: How to post code problems How to Post Performance Problems Create a Tally Function (fnTally)