select * into azad.[Security].[Tb_Sec_UserPermision14000114] from azad.[Security].[Tb_Sec_UserPermision] UPDATE azad.Security.Tb_Sec_UserPermision SET Fd_Usp_EndDate ='1401/01/01' from azad.Security.Tb_Sec_UserPermision inner join azad.Security.tb_sec_userlist on Fd_Usr_UserName=fd_usp_username where (Fd_Usr_Active = 1) and Fd_Usp_EndDate between '1399/11/28' and '1400/01/13'