USE [EnVisage]
GO

/****** Object:  StoredProcedure [dbo].[sp_DeletePeopleResource]    Script Date: 10/7/2014 12:28:41 PM ******/
DROP PROCEDURE [dbo].[sp_DeletePeopleResource]
GO

/****** Object:  StoredProcedure [dbo].[sp_DeletePeopleResource]    Script Date: 10/7/2014 12:28:41 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[sp_DeletePeopleResource] (@id uniqueidentifier)
AS
BEGIN
	begin transaction

	delete from PeopleResourceAllocation where ResourceId = @id
	delete from PeopleResource where Id = @id

	commit transaction
END



GO