30 Nov 2011 by Amir Mahfoozi
Hi Kevin,Try this one :WITH search_graph (ID,ProvinceID,Name, ProvDepth, CountryPath )AS ( SELECT [ID],[ProvinceID],[Name], 0 AS ProvDepth, cast(id as varchar(max)) as CountryPath FROM [Counties] WHERE provinceid = 0 UNION ALL SELECT e.ID, e.ProvinceID, e.Name,...