how to split the string using sql server

DECLARE @tmp TABLE (ID INT IDENTITY(1,1), SomeText VARCHAR(30))

INSERT INTO @tmp (SomeText)
SELECT 'LGTF/B203/11'
UNION ALL SELECT 'BGFF/B204/A/11'
UNION ALL SELECT 'GFTJ/B204/B/11'
UNION ALL SELECT 'LGTF/B204/C/11'
UNION ALL SELECT 'LATF/B205/11'
UNION ALL SELECT 'LSTF/B206/11'
UNION ALL SELECT 'GGTF/B207/11'
UNION ALL SELECT 'BGTF/B208/11'

;WITH CTE AS
(
	SELECT ID, SomeText, CHARINDEX('/', SomeText) AS StartLocation
	FROM @tmp
	WHERE CHARINDEX('/', SomeText)>0
	UNION ALL
	SELECT ID, SomeText, CHARINDEX('/', SomeText, StartLocation+1) AS StartLocation
	FROM CTE
	WHERE CHARINDEX('/', SomeText, StartLocation+1)>0
)
SELECT ID, SomeText, LEFT(SomeText, StartLocation -1) AS SplitedText
FROM (
	SELECT ID, SomeText, MAX(StartLocation) AS StartLocation
	FROM CTE
	GROUP BY ID, SomeText
) AS T
ORDER BY ID

ID  SomeText        SplitedText
1   LGTF/B203/11    LGTF/B203
2   BGFF/B204/A/11  BGFF/B204/A
3   GFTJ/B204/B/11  GFTJ/B204/B
4   LGTF/B204/C/11  LGTF/B204/C
5   LATF/B205/11    LATF/B205
6   LSTF/B206/11    LSTF/B206
7   GGTF/B207/11    GGTF/B207
8   BGTF/B208/11    BGTF/B208