USP_DECEASEDFINDERFILEAVAILABLE_GETPARAMETERS

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

      exec dbo.USP_GET_KEY_ACCESS;

      select 
        DECEASEDFINDER.FILENAME,
        DECEASEDFINDER.FILEUPLOADED,
        DECEASEDFINDER.FILEDOWNLOADED,
        DECEASEDFINDER.SABOTENJOBID,
        SABOTEN.USERNAME as SABOTENUSERNAME,
        convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY
      from 
        dbo.DECEASEDFINDER
        cross apply dbo.SABOTEN
      where 
        DECEASEDFINDER.ID = @ID;

      close symmetric key sym_BBInfinity;