Hey Guys,

I don't have any background about stored procedure, so I don't know the syntax and how it works. Basically what I'm trying to do is, I want to insert my data from one database to another and then upon successful transfer one of the column from the source database should be updated right away telling me that that record is transferred.

Can anyone give teach me how to do this. I created mine but I don't think this is right. Here is my code.

Code:
	INSERT INTO [DESTINATION].[dbo].[EMPLOYEES]
	       (EMPLOYEENO, LASTNAME, FIRSTNAME, MIDDLENAME, MIDDLEINITIAL, SUFFIXNAME, DATEHIRED, DEPARTMENT)
	SELECT [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[EMPLOYEENO],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[LASTNAME],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[FIRSTNAME],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[MIDDLENAME],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[MIDDLEINITIAL],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[SUFFIXNAME],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[DATEHIRED],
		   [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[DEPARTMENT]
	   FROM [SOURCE].[dbo].[TBL_APPLICANT_HIRED]
	 WHERE [SOURCE].[dbo].[TBL_APPLICANT_HIRED].[FLAG] = 'PENDING'

        UPDATE....