Object type: Stored Procedure (MS-SQL)
Parent: CustomerDBSQL

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spCCPOnDemandFileDelete](
@CallLtr VARCHAR(50),
@FileName VARCHAR(MAX)
)
AS
BEGIN
 
 
	IF EXISTS(SELECT 'x' FROM OnDemandFiles WHERE CallLtr = @CallLtr AND FileName = @FileName)
		BEGIN
 
			UPDATE OnDemandFiles
			SET	AvailableOnDemand = 0
			 WHERE CallLtr = @CallLtr AND FileName = @FileName
 
		END
 
	ELSE
		BEGIN
 
			INSERT INTO OnDemandFiles 
					(CallLtr, FileName, FileTitle, FileComments, AvailableOnDemand)
				VALUES
					(@CallLtr, @FileName, '', '', 0)
 
		END
 
SELECT @@ROWCOUNT
 
 
END
GO