 use [dbmsg]
 select * into [dbmsg].[dbo].[unauth_back1] from
(select no=row_number() over(partition by name order by getdate()),* from [dbmsg].[dbo].[unauth]) as t where no=1

