USP_MKTGIFTRECORDSOURCE_EDITLOAD

CREATE procedure dbo.[USP_MKTGIFTRECORDSOURCE_EDITLOAD]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [GS].[QUERYVIEWCATALOGID],
    [QV].[DISPLAYNAME] as [NAME],
    [QV].[OBJECTNAME],
    [QV].[PRIMARYKEYFIELD],
    [QV].[PRIMARYKEYTYPENAME],
    [GS].[APPEALSYSTEMIDFIELD],
    [GS].[APPEALIDFIELD],
    [GS].[APPEALDESCRIPTIONFIELD],
    [GS].[AMOUNTFIELD],
    [GS].[DONORIDFIELD],
    [GS].[SOURCECODEFIELD],
    [GS].[MAILINGIDFIELD],
    [GS].[DATEFIELD],
    [GS].[FINDERNUMBERFIELD],
    [GS].[DATEADDEDFIELD],
    [GS].[DONOTACKNOWLEDGEFIELD],
    [GS].[DONOTRECEIPTFIELD],
    [GS].[TSLONG],
    [GS].[DATECHANGEDFIELD],
    [GS].[BASECURRENCYIDFIELD],
    [GS].[LOOKUPIDFIELD]
  from dbo.[MKTGIFTRECORDSOURCE] as [GS]
  inner join dbo.[QUERYVIEWCATALOG] as [QV] on [QV].[ID] = [GS].[QUERYVIEWCATALOGID]
  where [GS].[ID] = @ID;

  return 0;