pg_crumbs_human

CREATE PROCEDURE [dbo].[pg_crumbs_human]
    @roles nvarchar(128),
    @itemID nvarchar(128) = '',
    @urlParameters CRUDFilterParameter READONLY
AS
BEGIN
declare @langID int
select @langID = try_cast(Value as int) from @urlParameters where [Key]='langID'

    CREATE TABLE dbo.#result (title nvarchar(256), link nvarchar(256), tooltip nvarchar(256), ord int)

    declare @fio nvarchar(256)
    select @fio = fio from hr_humans where id = @itemID


    insert into #result
    select iif(@langID=1, 'Home','Главная'), '/', '', 1
    union
    select 'База людей', '/hr', '', 2
    union
    select @fio, '', '', 3

    -- SELECT 1 Хлебные крошки
    select * from #result order by ord

    -- SELECT 2 Параметры страницы
    select 'Сотрудник '+ @fio Title
    drop table #result
END