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.
"Change is inevitable... change for the better is not".
"If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?" Helpful Links: How to post code problems How to Post Performance Problems Create a Tally Function (fnTally)