TreeOrder dict

CREATE PROCEDURE [dbo].[fm_tst-form-order_f2_dict]
   @username nvarchar(256),
   @itemID nvarchar(128)
AS
BEGIN
    select c.id Value,     -- id
        c.name as Text,
        isnull(c.parentID, 0) Value2  -- parentID
    from tst_categories c
    order by ord, id
END