CREATE TABLE #temptable(
    PlaceID int, 
    URLPath nvarchar(1000),
    PlaceName nvarchar(255) default('')

)

insert into #temptable
	EXEC Places_Get_ByURLString_Children_NextLayer 'TestArea/TestSubArea/'

select * from #temptable --join to records table... etc
drop table #temptable

CREATE PROCEDURE Places_Get_ByURLString_Children_NextLayer(
    @URLPath nvarchar(1000)
)
AS
--Set @URLPath = 'England/GreaterLondon/'

CREATE TABLE #paths(
    path nvarchar(1000), 
    URLPath nvarchar(1000), 
    ParentID int, 
    PlaceID int, 
    PlaceName nvarchar(255) default('')
)
--Insert the path data
INSERT INTO #paths EXEC Places_Get_All

Declare @nodeId int, @pad nvarchar(100), @lastCnt int

Set @Pad = '0000'
Set @nodeId = 0

IF EXISTS(SELECT PlaceID FROM #paths WHERE URLPath = @URLPath)
Begin
    SELECT
        @nodeId = PlaceID
    FROM
        #paths
    WHERE
        URLPath = @URLPath
End
--Select the children of the current location

Select distinct 
    B.PlaceID,
    A.URLPath,
    B.PlaceName
From
    #paths as A
Inner Join Places as B
    On A.PlaceID = B.PlaceID
Where 
    A.ParentID = @NodeId

DROP TABLE #paths