USP_PHONEFINDERGETPROCESS_GETPARAMETERS

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

    select
        PHONEFINDER.[FILENAME],
        PHONEFINDER.[ID] as [PHONEFINDERID],
        PHONEFINDER.[BATCHID],
        PHONEFINDER.[PRIMARYCONTACTNAME],
        PHONEFINDER.[SITEID],
        INSTALLATIONINFO.[INSTALLATIONNAME],
        INSTALLATIONINFO.[SERIALNUMBER]
    from
        dbo.PHONEFINDERGETPROCESS
        inner join dbo.PHONEFINDER on PHONEFINDER.[ID] = PHONEFINDERGETPROCESS.[PHONEFINDERID]
        cross join dbo.INSTALLATIONINFO
    where
        PHONEFINDERGETPROCESS.[ID] = @ID;

end