USP_EXPORTDEFINITION_LOAD

CREATE procedure dbo.[USP_EXPORTDEFINITION_LOAD]
(
  @ID uniqueidentifier
)
with execute as caller
as
  set nocount on;

  select
    EXPORTDEFINITION.EXPORTDEFINITIONXML,
    EXPORTDEFINITION.NAME,
    EXPORTDEFINITION.DESCRIPTION,
    EXPORTDEFINITION.SITEID,
    EXPORTDEFINITION.RECORDTYPEID,
    RECORDTYPE.NAME RECORDTYPE,
    EXPORTDEFINITION.LOCKFIELDS,
    EXPORTDEFINITION.ADDEDBYID,
    ADDEDBY.USERNAME as ADDEDBY_USERNAME,
    EXPORTDEFINITION.CHANGEDBYID,
    CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
    EXPORTDEFINITION.DATEADDED,
    EXPORTDEFINITION.DATECHANGED,
    EXPORTDEFINITION.VIEWDATAFORMTEMPLATEID,
    EXPORTDEFINITION.ISSYSTEM,
    EXPORTDEFINITION.USEFIELDNAMESFORONETOONECOLUMNHEADERS,
    EXPORTDEFINITION.USESHORTCOLUMNHEADERS,
    EXPORTDEFINITION.OUTPUTCOLUMNMETADATA
  from dbo.EXPORTDEFINITION
  inner join dbo.RECORDTYPE on RECORDTYPE.ID = EXPORTDEFINITION.RECORDTYPEID
  inner join dbo.CHANGEAGENT as ADDEDBY on EXPORTDEFINITION.ADDEDBYID = ADDEDBY.ID
  inner join dbo.CHANGEAGENT as CHANGEDBY on EXPORTDEFINITION.CHANGEDBYID = CHANGEDBY.ID
  where EXPORTDEFINITION.ID = @ID;

  return 0;