dbo.GS_RefreshEEAddressTrackerResults Stored Procedure

Properties

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

Parameters

Parameter	Direction	Data Type	Size
@EmployeeID	In	varchar	50
@CurrentAddressCode	In	varchar	15
@Result	In	varchar	50
@CurrentAddressString	In	varchar	500
@CurrentAddress1	In	varchar	61
@CurrentAddress2	In	varchar	61
@CurrentAddress3	In	varchar	61
@CurrentCity	In	varchar	35
@CurrentState	In	varchar	29
@CurrentZipCode	In	varchar	11
@CurrentZipExt	In	varchar	6
@CurrentCounty	In	varchar	61
@CurrentCountry	In	varchar	61
@RETURN_VALUE	Return Value	int	4

Objects that dbo.GS_RefreshEEAddressTrackerResults depends on

	Database Object	Object Type	Description	Dep Level
	dbo.GS_EEAddressTrackerResults	Table		1
	dbo.GS_EEAddressTrackerResultSuggestions	Table		1

Procedure Source Code


--procedure for updating EEAddressTracker Results Log
--Returns Primary key for GS_EEAddressTrackerResults to reference on following insert(s) to GS_EEAddressTrackerSuggestions
create procedure dbo.GS_RefreshEEAddressTrackerResults 
(
@EmployeeID varchar(50), @CurrentAddressCode varchar(15), @Result varchar(50), @CurrentAddressString varchar(500), @CurrentAddress1 varchar(61),
@CurrentAddress2 varchar(61), @CurrentAddress3 varchar(61), @CurrentCity varchar(35), @CurrentState varchar(29),
@CurrentZipCode varchar(11), @CurrentZipExt varchar(6), @CurrentCounty varchar(61), @CurrentCountry varchar(61)
) as 
BEGIN

IF EXISTS (select * from GS_EEAddressTrackerResults where EmployeeID = @EmployeeID) 
BEGIN
	DELETE from GS_EEAddressTrackerResultSuggestions where EmployeeID = @EmployeeID
	DELETE from GS_EEAddressTrackerResults where EmployeeID = @EmployeeID
END

INSERT into GS_EEAddressTrackerResults (EmployeeID, CurrentAddressCode, Result, CurrentAddressString, CurrentAddress1,
CurrentAddress2, CurrentAddress3, CurrentCity, CurrentState, CurrentZipCode, CurrentZipExt, CurrentCounty, CurrentCountry, Modified)
values (@EmployeeID, @CurrentAddressCode, @Result, @CurrentAddressString, @CurrentAddress1,
@CurrentAddress2, @CurrentAddress3, @CurrentCity, @CurrentState, @CurrentZipCode, @CurrentZipExt, @CurrentCounty, @CurrentCountry, CURRENT_TIMESTAMP);
SELECT SCOPE_IDENTITY();
end

Related Objects

dbo Schema
SQL Objects Database