/*
	Instructions - The following Stored Procedure assumes that the GALtoDB Table created in the versaSRS HelpDesk Database is named GAL. If the Table created is not named GAL, please ensure to change any reference to GAL in the following Stored Procedure to the appropriate table name. 
*/

CREATE PROCEDURE sp_CopyGALDataToSRSContacts
AS
BEGIN
	-- Delete all old imported records first --
	DELETE FROM tbl_Contacts Where RecNum < 0

	-- Insert new imported records to tbl_Contacts --
	INSERT INTO tbl_Contacts (RecNum, DateEntered, LastUpdated, FirstName, Surname, Company, BLocation, BDepartment, BStreet, BCity, BZip, BState, BCountry, BPhone, BFax, BMobile, BEmail, BWeb, HStreet, 
		HCity, HState, HZip, HCountry, HPhone, HFax)

	SELECT -1000000 - ENTRY_ID, getDate(), getDate(), GIVEN_NAME, SURNAME, COMPANY_NAME, OFFICE_LOCATION, BUS_DEPARTMENT_NAME, BUS_ADD_STREET, BUS_ADD_CITY, BUS_ADD_POSTAL_CODE, 
		BUS_ADD_STATE_OR_PROVINCE, BUS_ADD_COUNTRY, BUS_TELEPHONE_NUMBER, BUS_ADD_FAX_NUMBER, MOBILE_TELEPHONE_NUMBER, SMTP, BUS_HOME_PAGE, 
		H_ADD_STREET, H_ADD_CITY, H_ADD_STATE_OR_PROVINCE, H_ADD_POSTAL_CODE, H_ADD_COUNTRY, H_TELEPHONE_NUMBER, H_FAX_NUMBER From GAL
END
GO