Advertisement
hecrus

Tree checkboxes GetItem

Nov 3rd, 2020
1,241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[fm_tst-form-treeview_getItem]
  2.     @itemID int,   
  3.     @username nvarchar(256)
  4.  
  5. AS
  6. BEGIN
  7.     select  
  8.       STUFF((SELECT ',' + cast(id as nvarchar)
  9.       FROM tst_categories
  10.       WHERE selected=1
  11.       FOR XML PATH('')), 1, 1,'') f1  -- выделенные категории
  12. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement