pg_crumbs_hr

CREATE PROCEDURE [dbo].[pg_crumbs_hr]
    @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 'Главная', '/', '', 1
    union
    select 'База HR', '', '', 2

    -- SELECT 1
    select * from #result order by ord

    -- SELECT 2
    select 'Все сотрудники' Title
    drop table #result
END