Luke is correct, the parser is interpreting "GROUP" as the GROUP BY phrase. you need the square brackets.

I agree with Luke in that I'd rewrite this to be more readable.

The order of joins shouldn't matter, and that's what has been the advice, but you never know. However...

Happy Holidays and enjoy the end of the year, and be sure you celebrate something.

I knew Jeff would have something!

You have good points, and I'm not discounting them, but BOL saying 2+2=5 isn't the same as them documenting something and applying a terminology to it.

Microsoft calls a role "database...

No apology needed, bitbucket.

Thanks

I think 42 is the correct answer.

If you had to get some outside input for each one, that might not lend itself to a set based solution, especially if it's older. However if it were SQLCLR...

yep, saw that. actually all are possible except the log backup.

I've edited the post and I'll clean up the question somehow.

And I'd like to see you try.

I wonder how generating pin codes would be faster procedurally? Is it some randomness being introduced somehow?

OK, I see the argument here, but if you follow the four steps.

I'll look to reword the question.

I'm not sure it's even good English, and it's certainly not consistent.

I would agree it is important that we understand what we are talking about and use consistent terms. It's...

Definitely do some research about SP3 before you test or apply. There are some issues here to be aware of like the CU.

And once again we're off and running in a different direction.

I doubt this will eclipse the "Are the Posted Questions", but you never know.

Your logic isn't exiting anywhere. I'd run those selects and see what they're returning.