7,6,8,9,10, When we execute any sql statement on table SQL maintain Spooler and keep the table i data and perform operation on this .So after that it update main table. Ref-https://www.simple-talk.com/sql/learn-sql-server/operator-of-the-week---spools,-eager-spool/