USP_DECEASEDFINDERGETPROCESS_GETPARAMETERS

      CREATE procedure dbo.USP_DECEASEDFINDERGETPROCESS_GETPARAMETERS
      (
        @ID uniqueidentifier = null
      )
      as
      set nocount on;

      exec dbo.USP_GET_KEY_ACCESS;

      select 
        DECEASEDFINDER.ID as DECEASEDFINDERID,
        DECEASEDFINDER.FILENAME,
        DECEASEDFINDER.BATCHID,
        DECEASEDFINDER.SITEID,
        DECEASEDFINDER.PRIMARYCONTACTNAME,
        INSTALL.INSTALLATIONNAME,
        INSTALL.SERIALNUMBER,
        DECEASEDFINDER.SABOTENJOBID,
        SABOTEN.USERNAME as SABOTENUSERNAME,
        convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY
      from 
        dbo.DECEASEDFINDERGETPROCESS GET
      inner join 
        dbo.DECEASEDFINDER 
      on 
        DECEASEDFINDER.ID = GET.DECEASEDFINDERID
      cross join 
        dbo.INSTALLATIONINFO INSTALL
      cross apply dbo.SABOTEN
      where 
        GET.ID = @ID;

      close symmetric key sym_BBInfinity;