USP_COAUPDATEFILEAVAILABLE_GETPARAMETERS

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

    exec dbo.USP_GET_KEY_ACCESS;

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

    close symmetric key sym_BBInfinity;