USP_MKTSPONSORSHIPRECORDSOURCE_EDITLOAD

create procedure dbo.[USP_MKTSPONSORSHIPRECORDSOURCE_EDITLOAD]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [SS].[QUERYVIEWCATALOGID],
    [QV].[DISPLAYNAME] as [NAME],
    [QV].[OBJECTNAME],
    [QV].[PRIMARYKEYFIELD],
    [QV].[PRIMARYKEYTYPENAME],
    [SS].[SPONSORSHIPSYSTEMIDFIELD],
    [SS].[SPONSORIDFIELD],
    [SS].[ACTIONFIELD],
    [SS].[REASONFIELD],
    [SS].[GIFTSPONSORSHIPFIELD],
    [SS].[SPONSORSHIPOPPORTUNITYIDCHILDFIELD],
    [SS].[SPONSORSHIPOPPORTUNITYIDPROJECTFIELD],
    [SS].[SPONSORSHIPCHILDPROGRAMIDFIELD],
    [SS].[SPONSORSHIPPROJECTPROGRAMIDFIELD],
    [SS].[SPONSORSHIPLOCATIONIDFIELD],
    isnull([SS].[TSLONG], 0) as [TSLONG]
  from dbo.[MKTSPONSORSHIPRECORDSOURCE] as [SS]
  inner join dbo.[QUERYVIEWCATALOG] as [QV] on [QV].[ID] = [SS].[QUERYVIEWCATALOGID]
  where [SS].[ID] = @ID;

  return 0;