dbo.GS_RefreshSSNVTrackerResults Stored Procedure

Properties

Creation Date	9/25/2015 5:17 PM
Encrypted
Ansi Nulls

Parameters

Parameter	Direction	Data Type	Size
@EmployeeID	In	varchar	50
@ErrorCode	In	varchar	20
@ErrorString	In	varchar	250
@RETURN_VALUE	Return Value	int	4

Objects that dbo.GS_RefreshSSNVTrackerResults depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GS_SSNVTrackerResults	Table		1

Procedure Source Code


--procedure for updating SSNVTracker log
create procedure dbo.GS_RefreshSSNVTrackerResults (@EmployeeID varchar(50), @ErrorCode varchar(20), @ErrorString varchar(250)) as 
begin
delete from GS_SSNVTrackerResults where EmployeeID = @EmployeeID
insert into GS_SSNVTrackerResults (EmployeeID, ErrorCode, ErrorString, Modified)
values (@EmployeeID, @ErrorCode, @ErrorString, CURRENT_TIMESTAMP)
end

Related Objects

dbo Schema
SQL Objects Database