CREATE PROCEDURE [dbo].[fm_tst-form-treeview_f1_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 END