USP_DATAFORMTEMPLATE_VIEW_CONSOLIDATEDPROSPECTSEARCHPAGEEXPRESSION

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSOLIDATEDPROSPECTSEARCHPAGEEXPRESSION
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @MRU_ID01 uniqueidentifier = null output,
    @MRU_NAME01 nvarchar(100) = null output,
    @MRU_ID02 uniqueidentifier = null output,
    @MRU_NAME02 nvarchar(100) = null output,
    @MRU_ID03 uniqueidentifier = null output,
    @MRU_NAME03 nvarchar(100) = null output,
    @MRU_ID04 uniqueidentifier = null output,
    @MRU_NAME04 nvarchar(100) = null output,
    @MRU_ID05 uniqueidentifier = null output,
    @MRU_NAME05 nvarchar(100) = null output,
    @MRU_ID06 uniqueidentifier = null output,
    @MRU_NAME06 nvarchar(100) = null output,
    @MRU_ID07 uniqueidentifier = null output,
    @MRU_NAME07 nvarchar(100) = null output,
    @MRU_ID08 uniqueidentifier = null output,
    @MRU_NAME08 nvarchar(100) = null output,
    @MRU_ID09 uniqueidentifier = null output,
    @MRU_NAME09 nvarchar(100) = null output,
    @MRU_ID10 uniqueidentifier = null output,
    @MRU_NAME10 nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 1;

    select @NAME = NAME
    from dbo.PROSPECTSEARCH
    where ID = @ID;

  declare @MRULIST table  
  (
    ID uniqueidentifier,
    NAME nvarchar(100),
    ROWNUMBER int
  );

  insert into @MRULIST(ID, NAME, ROWNUMBER)
  select ID, NAME, ROWNUMBER from dbo.UFN_PROSPECTSEARCH_GETTOPN(10, @CURRENTAPPUSERID)

  select
    @MRU_ID01 = ID, 
    @MRU_NAME01 = NAME
  from @MRULIST
  where ROWNUMBER = 1;

  select
    @MRU_ID02 = ID, 
    @MRU_NAME02 = NAME
  from @MRULIST
  where ROWNUMBER = 2;

  select
    @MRU_ID03 = ID, 
    @MRU_NAME03 = NAME
  from @MRULIST
  where ROWNUMBER = 3;

  select
    @MRU_ID04 = ID, 
    @MRU_NAME04 = NAME
  from @MRULIST
  where ROWNUMBER = 4;

  select
    @MRU_ID05 = ID, 
    @MRU_NAME05 = NAME
  from @MRULIST
  where ROWNUMBER = 5;

  select
    @MRU_ID06 = ID, 
    @MRU_NAME06 = NAME
  from @MRULIST
  where ROWNUMBER = 6;

  select
    @MRU_ID07 = ID, 
    @MRU_NAME07 = NAME
  from @MRULIST
  where ROWNUMBER = 7;

  select
    @MRU_ID08 = ID, 
    @MRU_NAME08 = NAME
  from @MRULIST
  where ROWNUMBER = 8;

  select
    @MRU_ID09 = ID, 
    @MRU_NAME09 = NAME
  from @MRULIST
  where ROWNUMBER = 9;

  select
    @MRU_ID10 = ID, 
    @MRU_NAME10 = NAME
  from @MRULIST
  where ROWNUMBER = 10;

    return 0;