You forgot to specify the
columns list
in your INSERT command like:
SET IDENTITY_INSERT UserProfile ON
GO
INSERT
INTO UserProfile (UserId, UserName, Name, Family, P_T, P_N, Reshteh, CodeOzviat, CodeParvaneh)
SELECT
up.UserId-2002,
up.UserName,
up.Name,
up.Family,
up.P_T,
up.P_N,
up.Reshteh,
up.CodeOzviat,
up.CodeParvaneh
FROM
UserProfile up
WHERE (UserId =2336)
GO
SET IDENTITY_INSERT UserProfile OFF