USP_PEOPLEFINDERFILEAVAILABLE_GETPARAMETERS

Gets the parameters required to check if the response file is available.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE procedure dbo.USP_PEOPLEFINDERFILEAVAILABLE_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin

    select
        FILENAME,
        FILEUPLOADED,
        FILEDOWNLOADED
    from
        dbo.PEOPLEFINDER
    where
        ID = @ID;

end