You will probably want this as a stored procedure with @INSTR as a parameter, but it should work:
DECLARE @INSTR as VARCHAR(MAX)
SET @INSTR = 'One day in my life '
DECLARE @SEPERATOR as VARCHAR(1)
DECLARE @SP INT
DECLARE @VALUE VARCHAR(1000)
SET @SEPERATOR = ' '
WHILE PATINDEX('%' + @SEPERATOR + '%', @INSTR ) <> 0
BEGIN
SELECT @SP = PATINDEX('%' + @SEPERATOR + '%',@INSTR)
SELECT @VALUE = LEFT(@INSTR , @SP - 1)
SELECT @INSTR = STUFF(@INSTR, 1, @SP, '')
INSERT INTO MyTable (Title) VALUES (@VALUE)
END