ASP.NET

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

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: May 2009

Posts: 40

Reputation: phoenix_dwarf is an unknown quantity at this point

Solved Threads: 0

phoenix_dwarf phoenix_dwarf is offline

Offline

Light Poster

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

Oct 24th, 2009

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:

 Help with Code Tags 
 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

•

Join Date: May 2009

Posts: 40

Reputation: phoenix_dwarf is an unknown quantity at this point

Solved Threads: 0

phoenix_dwarf phoenix_dwarf is offline

Offline

Light Poster

Oct 24th, 2009

Well I saw now that if i take out "WHERE Upl_Tel LIKE @tel" it works but now it also moves the data that i dont want moved??? Any ideas...

•

Join Date: May 2009

Posts: 40

Reputation: phoenix_dwarf is an unknown quantity at this point

Solved Threads: 0

phoenix_dwarf phoenix_dwarf is offline

Offline

Light Poster

Oct 27th, 2009

NVM! I found out this code works 100% perfectly...my bad! (I converted a string to an int and so lost some zero values and that was my problem) tnx anyway!