USP_MKTFINDERFILE_EDIT_LOAD

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

  select 
    FF.[SEGMENTATIONID],
    FF.[VENDORID],
    1 [RECORDSOURCEHIDDEN],
    LL.[RECORDSOURCEID],
    FF.[CATEGORYCODEID] [CATEGORY],
    FF.[ORDERDATE],
    FF.[EXPIRATIONDATE],
    FF.[FILENAME],
    FF.[QUANTITY],
    FF.[TSLONG]  
  from dbo.[MKTFINDERFILEIMPORTPROCESS] FF
  inner join dbo.[MKTLISTLAYOUT] LL on LL.[ID] = FF.[LISTLAYOUTID]
  where FF.[ID] = @ID;

  return 0;