WITH    Category_Tree          AS ( SELECT   Code               FROM     SubjectDB.Supplier.SupplierCategory               WHERE    Code LIKE ‘0101%‘             )SELECT  *FROM    SubjectDB.Supplier.SupplierCategoryWHERE   Code IN ( SELECT    *                      FROM      Category_Tree )