====== dbo.spCCPOnDemandFileDelete======

Object type: Stored Procedure (MS-SQL)\\
Parent: [[internal:dbsql:customerdbsql:start|CustomerDBSQL]]
\\ \\

<code sql>
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

</code>