USP_COAUPDATEGETPROCESS_GETPARAMETERS

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

    exec dbo.USP_GET_KEY_ACCESS;

    select
        COAUPDATE.ID as COAUPDATEID,
        COAUPDATE.FILENAME,
        COAUPDATE.BATCHID,
        DATA.ADDRESSFORMATTINGCODE,
        DATA.DONOTABBREVIATE,
        DATA.CAPITALIZE,
        COAUPDATE.SITEID,
        COAUPDATE.PRIMARYCONTACTNAME,
        INSTALL.INSTALLATIONNAME,
        INSTALL.SERIALNUMBER,
        COAUPDATE.SABOTENJOBID,
        SABOTEN.USERNAME as SABOTENUSERNAME,
        convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY
    from
        dbo.COAUPDATEGETPROCESS GET
        inner join dbo.COAUPDATE
            on COAUPDATE.ID = GET.COAUPDATEID
        inner join dbo.DATATUNEUP DATA
            on COAUPDATE.DATATUNEUPID = DATA.ID
        cross join dbo.INSTALLATIONINFO INSTALL
        cross apply dbo.SABOTEN
    where
        GET.ID = @ID;

    close symmetric key sym_BBInfinity;