Human SQL Page

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)

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

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

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