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

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