CREATE FUNCTION FNC_SPLIT(@MYSTR VARCHAR(500), @DELIMITER CHAR(1))
RETURNS @MYTBL  TABLE (idx smallint, value varchar(8000))
AS 
BEGIN
 DECLARE @RET VARCHAR(500)
 DECLARE @INDEX INT
 DECLARE @COUNTER smallint
 
 --Get the first position of delimiter in the main string
 SET @INDEX = CHARINDEX(@DELIMITER,@MYSTR)
 SET @COUNTER = 0
 
 --Loop if delimiter exists in the main string
 WHILE @INDEX > 0
 BEGIN
  --extract the result substring before the delimiter found
  SET @RET = SUBSTRING(@MYSTR,1, @INDEX-1 )
  --set mainstring right part after the delimiter found
  SET @MYSTR = SUBSTRING(@MYSTR,@INDEX+1 , LEN(@MYSTR) - @INDEX )
  --increase the counter
  SET @COUNTER = @COUNTER  + 1 
  --add the result substring to the table
  INSERT INTO @MYTBL (idx, value)
  VALUES (@COUNTER, @RET)
  --Get the next position of delimiter in the main string
  SET @INDEX = CHARINDEX(@DELIMITER,@MYSTR)
 END
 
 --if no delimiter is found then simply add the mainstring to the table
 IF @INDEX = 0 
 BEGIN
  SET @COUNTER = @COUNTER  + 1
  INSERT INTO @MYTBL (idx, value)
  VALUES (@COUNTER, @MYSTR)
 END 
 RETURN   
END
 
GO
SELECT value FROM FNC_SPLIT(\'2013,2014,2015\',\',\')
GO
DROP FUNCTION FNC_SPLIT

DECLARE @xml varchar(max)
DECLARE @doc int
SET @xml =\'
<?xml version="1.0" encoding="UTF-8"?> 
<Request>
<Date Year="2013"/>
<Date Year="2014"/>
<Date Year="2015"/>
</Request>\'
EXEC sp_xml_preparedocument @doc OUTPUT, @xml
CREATE TABLE #Temp([Year] varchar(100))
INSERT INTO #Temp
SELECT [Year] FROM 
OPENXML (@doc, \'/Request/Date\', 1)
WITH (Year varchar(100))
EXEC sp_xml_Removedocument @doc
SELECT * FROM #Temp
Drop Table #Temp

SET @xml =\'
<?xml version="1.0" encoding="UTF-8"?> 
<Request>
<Date Year="2013" Date="10"/>
<Date Year="2014" Date="10"/>
<Date Year="2015" Date="10"/>
</Request>\'