daily pastebin goal
47%
SHARE
TWEET

saf

a guest Nov 9th, 2017 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.   with category_cte
  3.   as
  4.     (
  5.         SELECT * FROM [PhoneConstructor.Host.DataEntities.Categorys] AS BaseCategory
  6.         WHERE BaseCategory.ParentId IS NULL
  7.  
  8.         UNION ALL
  9.  
  10.         SELECT SubCategory.*
  11.         FROM [PhoneConstructor.Host.DataEntities.Categorys] AS SubCategory
  12.         JOIN category_cte
  13.         ON SubCategory.ParentId = category_cte.Id
  14.     )
  15.   SELECT * FROM category_cte
RAW Paste Data
Top