USP_EMAILFINDERGETPROCESS_GETPARAMETERS

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

    select 
        EMAILFINDER.ID as EMAILFINDERID,
        EMAILFINDER.FILENAME,
        EMAILFINDER.BATCHID,
        EMAILFINDER.SITEID,
        EMAILFINDER.PRIMARYCONTACTNAME,
        INSTALLATIONINFO.INSTALLATIONNAME,
        INSTALLATIONINFO.SERIALNUMBER
    from 
        dbo.EMAILFINDERGETPROCESS
    inner join
        dbo.EMAILFINDER on EMAILFINDER.ID = EMAILFINDERGETPROCESS.EMAILFINDERID
    cross join
        dbo.INSTALLATIONINFO
    where 
        EMAILFINDERGETPROCESS.ID = @ID;
end