USP_COAUPDATECREATEPROCESS_GETPARAMETERS

create procedure dbo.USP_COAUPDATECREATEPROCESS_GETPARAMETERS
(
  @ID uniqueidentifier = null
)
as
  set nocount on;

  exec dbo.USP_GET_KEY_ACCESS;

  select
    COAUPDATE.SITEID,
    COAUPDATE.ID as COAUPDATEID,
    COAUPDATE.NAME,
    [CREATE].IDSETREGISTERID,
    [CREATE].INCLUDECONSTITUENTDNM,
    [CREATE].ADDRESSINCLUDECODE,
    [CREATE].ADDRESSTYPECODEID,
    [CREATE].INCLUDEADDRESSESDNM,
    [CREATE].CREATEOUTPUTIDSET,
    [CREATE].OUTPUTIDSETNAME,
    [CREATE].OVERWRITEOUTPUTIDSET,
    [CREATE].OUTPUTIDSETRECORDTYPEID,
    INSTALL.INSTALLATIONNAME,
    INSTALL.SERIALNUMBER,
    COAUPDATE.PRIMARYCONTACTNAME,
    COAUPDATE.PRIMARYCONTACTEMAIL,
    COAUPDATE.PRIMARYCONTACTPHONE,
    COAUPDATE.ALTERNATECONTACTNAME,
    COAUPDATE.ALTERNATECONTACTEMAIL,
    COAUPDATE.ALTERNATECONTACTPHONE,
    COAUPDATE.BATCHID,
    COAUPDATE.BATCHAPPUSERID,
    [CREATE].SUBMITHOUSEHOLD,
    SABOTEN.USERNAME as SABOTENUSERNAME,
    convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY,
    INSTALL.CLARIFYSITEID,
    SABOTEN.NAICS,
    SABOTEN.ADDRESS,
    SABOTEN.CITY,
    SABOTEN.POSTCODE,
    STATE.ABBREVIATION [STATEABBREVIATION],
    TITLECODE.DESCRIPTION [PRIMARYCONTACTTITLE]
  from dbo.COAUPDATECREATEPROCESS [CREATE]
  inner join dbo.COAUPDATE on COAUPDATE.ID = [CREATE].COAUPDATEID
  left join dbo.[TITLECODE] on [TITLECODE].[ID] = [COAUPDATE].[PRIMARYCONTACTTITLECODEID]
  cross join dbo.INSTALLATIONINFO INSTALL
  cross join dbo.SABOTEN
  left join dbo.[STATE] on [STATE].[ID] = [SABOTEN].[STATEID]
  where [CREATE].ID = @ID;

  close symmetric key sym_BBInfinity;