USP_MKTSPONSORSHIPRECORDSOURCE_EDITLOAD_2

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

  select
    [SS].[QUERYVIEWCATALOGID],
    [QV].[DISPLAYNAME] as [NAME],
    [QV].[OBJECTNAME],
    [QV].[PRIMARYKEYFIELD],
    [QV].[PRIMARYKEYTYPENAME],
    [SS].[SPONSORSHIPOPPORTUNITYIDCHILDFIELD] as [CHILDIDFIELD],
    [SS].[SPONSORSHIPCHILDPROGRAMIDFIELD] as [CHILDPROGRAMIDFIELD],
    [SS].[GIFTSPONSORSHIPFIELD] as [ISGIFTFIELD],
    [SS].[ACTIONFIELD] as [LASTACTIONFIELD],
    [SS].[REASONFIELD] as [LASTACTIONREASONIDFIELD],
    [SS].[SPONSORSHIPLOCATIONIDFIELD] as [LOCATIONIDFIELD],
    [SS].[SPONSORSHIPOPPORTUNITYIDPROJECTFIELD] as [PROJECTIDFIELD],
    [SS].[SPONSORSHIPPROJECTPROGRAMIDFIELD] as [PROJECTPROGRAMIDFIELD],
    [SS].[SPONSORIDFIELD],
    [SS].[SPONSORSHIPSYSTEMIDFIELD] as [SYSTEMIDFIELD],
    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;