How do I move data from one table to another using asp.net and MS SQL?

Expand Post »

Hi,

I'm trying to move "leftover" data from one database table to another after the user clicked on a button. Please can anyone give me some advise. This is kinda really urgent plz.

Everytime i run my app it gives no error but also doesn't move my data.

I'm using a stored procedure and this is my code:

ASP.NET Syntax (Toggle Plain Text)
ALTER PROCEDURE dbo.MoveDeleteUplHis
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
	@tel text
AS
SET IDENTITY_INSERT CompanyHistory ON
INSERT INTO CompanyHistory (CH_ID, CH_Tel, CH_SDT, CH_Duration, CH_Transaction, CH_Destination, CH_Amount, CH_Roaming, CH_Discount, CH_Status) 
SELECT Upl_ID, Upl_Tel, Upl_SDT, Upl_Duration, Upl_Transaction, Upl_Destination, Upl_Amount, Upl_Roaming, Upl_Discount, Upl_Status
FROM Upload WHERE Upl_Tel LIKE @tel;
SET IDENTITY_INSERT CompanyHistory ON
 
DELETE FROM Upload WHERE Upl_Tel LIKE @tel;
 
	/* SET NOCOUNT ON */ 
	RETURN
ALTER PROCEDURE dbo.MoveDeleteUplHis
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
	@tel text
AS
SET IDENTITY_INSERT CompanyHistory ON
INSERT INTO CompanyHistory (CH_ID, CH_Tel, CH_SDT, CH_Duration, CH_Transaction, CH_Destination, CH_Amount, CH_Roaming, CH_Discount, CH_Status) 
SELECT Upl_ID, Upl_Tel, Upl_SDT, Upl_Duration, Upl_Transaction, Upl_Destination, Upl_Amount, Upl_Roaming, Upl_Discount, Upl_Status
FROM Upload WHERE Upl_Tel LIKE @tel;
SET IDENTITY_INSERT CompanyHistory ON

DELETE FROM Upload WHERE Upl_Tel LIKE @tel;

	/* SET NOCOUNT ON */ 
	RETURN

Last edited by phoenix_dwarf; Oct 24th, 2009 at 11:38 am. Reason: Missing code

Similar Threads

Update from Asp.net to Sql server db in ASP.NET

phoenix_dwarf

Reputation Points: 11

Solved Threads: 0

Junior Poster in Training