How to use Cursor to Insert data into table

GO
/****** Object: StoredProcedure [dbo].[InsertData] Script Date: 04/08/2011 05:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[InsertData]
as
begin
DECLARE @MODEL_NO varchar(16),@MODEL_SERNO nvarchar(15),@MFG_DATE datetime,
@MFG_SOURCE nvarchar(5),@CUST_NO nvarchar(10),@ORDER_NO nvarchar(10),
@INVOICE_NO nvarchar(10),@SHIP_DATE datetime,@CREATE_DATE datetime,
@USER_ID nvarchar(10)
DECLARE wtytprod_cursor CURSOR FOR SELECT * FROM dbo.Temporary
OPEN wtytprod_cursor
FETCH NEXT FROM wtytprod_cursor
INTO @MODEL_NO,@MODEL_SERNO,@MFG_DATE,@MFG_SOURCE,@CUST_NO,@ORDER_NO,@INVOICE_NO,@SHIP_DATE,@CREATE_DATE,@USER_ID
WHILE @@FETCH_STATUS = 0
BEGIN
if exists(select * from dbo.WTYTPROD where MODEL_SERNO =@MODEL_SERNO)
update dbo.WTYTPROD set MODEL_NO =@MODEL_NO,MODEL_SERNO =@MODEL_SERNO,MFG_DATE =@MFG_DATE,MFG_SOURCE =@MFG_SOURCE,CUST_NO =@CUST_NO,ORDER_NO =@ORDER_NO,INVOICE_NO=@INVOICE_NO,SHIP_DATE=@SHIP_DATE,CREATE_DATE=@CREATE_DATE,[USER_ID]=@USER_ID where MODEL_SERNO=@MODEL_SERNO
else
insert into dbo.WTYTPROD (MODEL_NO,MODEL_SERNO,MFG_DATE,MFG_SOURCE,CUST_NO,ORDER_NO,
INVOICE_NO,SHIP_DATE,CREATE_DATE,USER_ID)values(@MODEL_NO,@MODEL_SERNO,@MFG_DATE,@MFG_SOURCE,@CUST_NO,@ORDER_NO,@INVOICE_NO,@SHIP_DATE,@CREATE_DATE,@USER_ID)
FETCH NEXT FROM wtytprod_cursor
INTO @MODEL_NO,@MODEL_SERNO,@MFG_DATE,@MFG_SOURCE,@CUST_NO,@ORDER_NO,@INVOICE_NO,@SHIP_DATE,@CREATE_DATE,@USER_ID
END
CLOSE wtytprod_cursor
DEALLOCATE wtytprod_cursor
END
GO