=====================================

create table #test2 (rowid int)

insert into #test2

select top 10 row_number () over (order by name), name

from master.sys.all_columns

======================================

The above code will fail because in the 'Table Definition' I have provided 1 column, where as I am trying to insert 2 columns, which is inappropriate.

Can anybody, please help me understand where the 'TWEAK' is? I couldn't catch it !! 😉