USP_MKTRECORDSOURCEFIELDMAPPINGS_EDITLOAD

CREATE procedure dbo.[USP_MKTRECORDSOURCEFIELDMAPPINGS_EDITLOAD]
(
  @RECORDSOURCEID uniqueidentifier = null
)
as
  set nocount on;

  select
    [FULLNAMEFIELD],
    [FIRSTNAMEFIELD],
    [MIDDLENAMEFIELD],
    [LASTNAMEFIELD],
    [ORGNAMEFIELD],
    [TITLEFIELD],
    [SUFFIXFIELD],
    [COUNTRYFIELD],
    [ADDRESSLINE1FIELD],
    [ADDRESSLINE2FIELD],
    [ADDRESSLINE3FIELD],
    [ADDRESSLINE4FIELD],
    [ADDRESSLINE5FIELD],
    [CITYFIELD],
    [STATEFIELD],
    [POSTCODEFIELD],
    [CARTFIELD],
    [DPCFIELD],
    [LOTFIELD],
    [PHONENUMBERFIELD],
    [EMAILADDRESSFIELD],
    [FIRSTGIFTDATEFIELD],
    [HOUSEHOLDIDFIELD],
    [HEADOFHOUSEHOLDFIELD],
    [ISHOUSEHOLDFIELD],
    [DATELASTCHANGEDFIELD],
    [ADDRESSEEFIELD],
    [SALUTATIONFIELD],
    [TSLONG],
    [LOOKUPIDFIELD]
  from dbo.[MKTRECORDSOURCEFIELDMAPPINGS]
  where [ID] = @RECORDSOURCEID;

  return 0;