Copy row data from a table and insert into same table as a new row in SQL Server

Hi Alladin,

Refer the below query.

SQL

DECLARE @UserTask TABLE (TaskId INT IDENTITY, UserId INT,ProjectId INT,TaskDescription VARCHAR(50),
            EstimateTime INT,ActualTime INT,Completed INT,Comments VARCHAR(50))
INSERT INTO @UserTask (UserId,ProjectId,TaskDescription,EstimateTime,ActualTime,Completed,Comments) 
		VALUES(1,1,'Task1',200,150,99,'Ok'),(2,1,'Task2',210,160,300,'Good'),(3,2,'Task3',100,90,90,'Best')

SELECT * FROM @UserTask

SELECT UserId,ProjectId,TaskDescription,EstimateTime,ActualTime,Completed,Comments FROM @UserTask Where Completed < 100

INSERT INTO @UserTask (UserId,ProjectId,TaskDescription,EstimateTime,ActualTime,Completed,Comments) 
SELECT UserId,ProjectId,TaskDescription,EstimateTime,ActualTime,Completed,Comments FROM @UserTask Where Completed < 100

SELECT * FROM @UserTask

Screenshot