Advertisement
Guest User

saf

a guest
Nov 9th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.35 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement