Advertisement
hecrus

TreeOrder dict

Nov 4th, 2020
2,411
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.28 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[fm_tst-form-order_f2_dict]
  2.    @username nvarchar(256),
  3.    @itemID nvarchar(128)
  4. AS
  5. BEGIN
  6.     select c.id Value,     -- id
  7.         c.name as Text,    
  8.         isnull(c.parentID, 0) Value2  -- parentID
  9.     from tst_categories c  
  10.     order by ord, id
  11. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement