Description: ALTERPROCEDURE[dbo].[sp_UpdateCurrentParcels] ASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SETNOCOUNTON;BEGINTRYBEGINTRANDELETEFROMFT_CURRENTPARCELS;InsertIntoFT_CURRENTPARCELS(OBJECTID,PIN,OWNER,LOCATION,ACRES,SHAPE,GlobalID)selectOBJECTID,PIN,OWNER,LOCATION,ACRES,SHAPE,GlobalID fromvw_CurrentParcels;COMMITTRANENDTRYBEGINCATCHIF@@TRANCOUNT>0ROLLBACKTRANRAISEERROR(SELECTERROR_MESSAGE(),ERROR_SEVERITY(),1)ENDCATCHEND