USP_PHONEFINDERRESUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_PHONEFINDERRESUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    select
        PHONEFINDER.[ID],
        PHONEFINDER.[REQUESTFILE],
        PHONEFINDER.[FILENAME],
        PHONEFINDER.[FILEUPLOADED],
        PHONEFINDER.[FILEDOWNLOADED]
    from    
        dbo.PHONEFINDERRESUBMITPROCESS
        inner join dbo.PHONEFINDER on PHONEFINDER.[ID] = PHONEFINDERRESUBMITPROCESS.[PHONEFINDERID]
    where
        PHONEFINDERRESUBMITPROCESS.[ID] = @ID;

    return 0;

end