CREATE PROCEDURE [dbo].[fm_tst-dynTreeItem_getItem]

CREATE PROCEDURE [dbo].[fm_tst-dynTreeItem_getItem]
    @itemID int,
	@username nvarchar(256)

AS
BEGIN
	select '<b>Name:</b> ' + name + '<br>'+
    	'<b>ID:</b> '+ cast(id as nvarchar) + '<br>'+
        '<b>Parent:</b> '+ isnull((select name from tst_cats where id =cat.parentID), 'no parent') + '<br>' +
        '<b>Nodes:</b> '+ cast((select count(*)
 from tst_cats where parentID = cat.id) as nvarchar) text
    from tst_cats cat where id = @itemID

    select 'white' background

END