USP_MKTMEMBERSHIPRECORDSOURCE_EDITLOAD

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

  select
    [MS].[QUERYVIEWCATALOGID],
    [QV].[DISPLAYNAME] as [NAME],
    [QV].[OBJECTNAME],
    [QV].[PRIMARYKEYFIELD],
    [QV].[PRIMARYKEYTYPENAME],
    [MS].[MEMBERSHIPSYSTEMIDFIELD],
    [MS].[MEMBERIDFIELD],
    [MS].[MEMBERFIELD],
    [MS].[GIVENBYIDFIELD],
    [MS].[GIVENBYFIELD],
    [MS].[EXPIRATIONDATEFIELD],
    [MS].[ISGIFTFIELD],
    [MS].[JOINDATEFIELD],
    [MS].[LASTRENEWEDONDATEFIELD],
    [MS].[LEVELFIELD],
    [MS].[PROGRAMFIELD],
    [MS].[SENDRENEWALFIELD],
    [MS].[STATUSFIELD],
    [MS].[TERMFIELD],
    [MS].[TYPEFIELD],
    isnull([MS].[TSLONG], 0) as [TSLONG],
    [MS].[LOOKUPIDFIELD]
  from dbo.[MKTMEMBERSHIPRECORDSOURCE] as [MS]
  inner join dbo.[QUERYVIEWCATALOG] as [QV] on [QV].[ID] = [MS].[QUERYVIEWCATALOGID]
  where [MS].[ID] = @ID;

  return 0;