GOT IT! I added "newid() as newid" as the 2nd column to each of the derived tables. That satisfied SQLServer syntax.

Thanks VERY much for...

SQLServer gets the error:

Server: Msg 104, Level 15, State 1, Line 1

ORDER BY items must appear in the select list if the statement...

Thanks very much!

Jon