daily pastebin goal
62%
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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top