DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/5d/5dd415aef74acabb23e7bc0a8ce4f6b73818302c.svn-base

<EFBFBD><EFBFBD>
ALTER PROCEDURE [dbo].[sp_GroupChannelSettingsDelete]
			 @ChannelId				bigint = 0 
			,@SettingId				int = null
		    ,@errorNumber			int				output
		    ,@errorMessage			nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0);

	begin try
		if ( @SettingId IS NULL )
			begin
			delete from [dbo].[GroupChannelSettings] WHERE ([ChannelId] = @ChannelId)
			end
		else
			begin
			delete from [dbo].[GroupChannelSettings] WHERE (([ChannelId] = @ChannelId) AND ([SettingId] = @SettingId))
			end
	end try
	begin catch
		set @errorMessage	= error_message()
		set @errorNumber	= error_number()
	end catch;	
END