USP_PEOPLEFINDERGETPROCESS_GETPARAMETERS

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

    select 
        PEOPLEFINDER.ID as PEOPLEFINDERID,
        PEOPLEFINDER.FILENAME,
        PEOPLEFINDER.BATCHID,
        PEOPLEFINDER.SITEID,
        PEOPLEFINDER.PRIMARYCONTACTNAME,
        INSTALLATIONINFO.INSTALLATIONNAME,
        INSTALLATIONINFO.SERIALNUMBER
    from 
        dbo.PEOPLEFINDERGETPROCESS
    inner join
        dbo.PEOPLEFINDER on PEOPLEFINDER.ID = PEOPLEFINDERGETPROCESS.PEOPLEFINDERID
    cross join
        dbo.INSTALLATIONINFO
    where 
        PEOPLEFINDERGETPROCESS.ID = @ID;

end