DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/ca/ca2708dd19a51d1ca210c947bf0bc6302df75e35.svn-base

<EFBFBD><EFBFBD>CREATE PROCEDURE [dbo].[sp_TestSetupROIsDelete]
			@TestSetupId				int,
			@errorNumber				int				output,
			@errorMessage				nvarchar(250)	output 
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)

	SET NOCOUNT ON;
	IF(@TestSetupId IS NULL)
	BEGIN
		SET @errorNumber=2
		SET @errorMessage='Must specify a TestSetupId'
		return
	END
	ELSE
	BEGIN
		DELETE FROM [dbo].ROIPeriodChannels WHERE [TestSetupROIId] IN (SELECT [TestSetupROIId] FROM [dbo].[TestSetupROIs] WHERE [TestSetupId] = @TestSetupId)
		DELETE FROM [dbo].TestSetupROIs WHERE [TestSetupId]=@TestSetupId
	END
END