This is why SQL Server needs to get with the program and start paying attention to ANSI.<BR><BR>I imagine temp tables will be more efficient. If nothing else, they're more SQL-like.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.