Ruslan_Rayanov

pg_crumbs_hr

Oct 10th, 2020
32
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROCEDURE [dbo].[pg_crumbs_hr]
  2.     @roles nvarchar(128),
  3.     @itemID nvarchar(128) = '',
  4.     @urlParameters CRUDFilterParameter READONLY
  5. AS
  6. BEGIN
  7. declare @langID int
  8. select @langID = try_cast(Value as int) from @urlParameters where [Key]='langID'
  9.     CREATE TABLE dbo.#result (title nvarchar(256), link nvarchar(256), tooltip nvarchar(256), ord int)
  10.  
  11.     insert into #result
  12.     select 'Главная', '/', '', 1
  13.     union
  14.     select 'База HR', '', '', 2
  15.  
  16.     -- SELECT 1
  17.     select * from #result order by ord
  18.    
  19.     -- SELECT 2
  20.     select 'Все сотрудкники' Title
  21.     drop table #result
  22. END
RAW Paste Data