USP_PHONEFINDER_FILEAVAILABLE_GETPARAMETERS

Gets parameters necessary for checking file PhoneFinder process file availability

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE procedure dbo.USP_PHONEFINDER_FILEAVAILABLE_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    set nocount on;

    select
        PHONEFINDER.[FILENAME],
        PHONEFINDER.[FILEUPLOADED],
        PHONEFINDER.[FILEDOWNLOADED]
    from
        dbo.PHONEFINDER
    where
        PHONEFINDER.[ID] = @ID;
end