USP_IMPORTSELECTIONPROCESS_EDIT_LOAD

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

  select
    [IMPORTSELECTIONPROCESS].[NAME],
    [RECORDTYPE].[NAME] as [RECORDTYPE],
    [IMPORTSELECTIONPROCESS].[RECORDTYPEID],
    [IMPORTSELECTIONPROCESS].[IDFIELD],
    [IMPORTSELECTIONPROCESS].[IDTYPECODE],
    [IMPORTSELECTIONPROCESS].[ALTERNATELOOKUPIDTYPECODEID],
    [IMPORTSELECTIONPROCESS].[TSLONG]
  from dbo.[IMPORTSELECTIONPROCESS]
  inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [IMPORTSELECTIONPROCESS].[RECORDTYPEID]
  where [IMPORTSELECTIONPROCESS].[ID] = @ID;

  return 0;