====== dbo.spCCPGetOnDemandFiles ======

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].[spCCPGetOnDemandFiles](
@CallLtr varchar(50),
@DirectoryPath varchar(500)
)
As
Begin
	
	Set @DirectoryPath	= @DirectoryPath + '%'

	Select * from OnDemandFiles where CallLtr = @CallLtr and [FileName] like @DirectoryPath

End
GO

</code>