• How about joined aggregate values?

    Also, you missed out the rather handy ability to use variables in the set.

    eg

    set @Variable = column = @variable + stuff

    etc