So many ways to construct T-SQL, thanks for sharing!

Thanks it's good to see how others put together T-SQL and its built-in functions to come up with clever solutions. Keeps the mind nimble.

Excellent question!

I missed the semicolon and was bummed I chose the wrong answer because I didn't read all the SQL.

Code reading is a skill in which I should be proficient...

That was great!

And we should have known better it being April 1st and all. This would have been a very enjoyable "Candid Camera" segment. It would...

Anchorage, Alaska

jump! -- as in the water's fine -- :hehe:

I appreciate the QOD question because it encourages me to read BOL more and the questions and ensuing discussions helps me to better understand some of the BOL entries. ...

This was a great question! 3.30 was my response...

I didn't remember I read about SQL Server integer division until AFTER I got the question wrong and ...

What a fun idea!

LOAD CURRENT_USER

AUTHORIZATION UPDATE ALL

BROWSE NOT WITH CONSTRAINT