• I checked this on 2005, and both answers marked as correct (A and D) work.

    You have to run each SET/SELECT and then a SELECT @val for each answer, with separate executions. I added a drop table #empty at the end as well.

    The question has been edited to say "select all that apply"

    and I'm awake, Hugo!