roger.plowman (4/25/2011)
Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?Unless I'm crazy you can't insert 'a' into the nDex field because nDex is an integer. When that script is copied to SSMS you get 3 incorrect sytax errors.
So the correct answer is "none of the above". 🙂 Because it's *guaranteed* you won't get any return values!
The insert will fail in 2k5, you have to change it to union alls... other than that the script will work (tho not as obviously intented and hence the question here)