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

Alladin

SOLVED CLOSED ACTIVE ANSWERED
User: Alladin
Posted: on Nov 11, 2015 02:08 AM
Forum: SQL Server
Answer: 1
Views: 5378

And in new record task id of table should be saved in previousTaskId

SELECT 
			TaskId,
			dbo.GetUsernameById(UserId) AS 'Username',
		    dbo.GetProjectNameById(ProjectId) AS 'ProjectName',
	        TaskDescription,
	        EstimateTime,
	        ActualTime,
	        Completed,
	        Comments
	        	FROM UserTask Where Completed < 100
	        	
AND
	        	
	        	 INSERT INTO UserTask
	      (	       
	        UserId,
	        ProjectId,
	        TaskDescription,
	        EstimateTime,
	        ActualTime,
	        Completed,
	        Comments,
	        PreviousTaskId
	           
	      )
	    VALUES
	      (	       
	        @UserId,
	        @ProjectId,
	        @TaskDescription,
	        @EstimateTime,
	        @ActualTime,
	        @Completed,
	        @Comments,
	        @TaskId
	      )

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Nov 11, 2015 05:51 AM
Modified: on Sep 04, 2017 06:51 AM
Report

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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

Company

Explore

Follow us

Contact Us