getting the words from one table and putting them into another table in sql server.

--The function returns a table, so you can select from it.
select * from dbo.SplitFunction("This is a test String", ' ')

/*
Return something like:
This
is
a
test
String
*/

CREATE FUNCTION [dbo].[SDF_SplitString] 
(
    @sString nvarchar(2048),
    @cDelimiter nchar(1)
)
RETURNS @tParts TABLE ( part nvarchar(2048) ) 
AS BEGIN     
    if @sString is null return     
    declare @iStart int, @iPos int     
    if substring( @sString, 1, 1 ) = @cDelimiter     
    begin         
        set @iStart = 2
        insert into @tParts values( null )
    end
    else
        set @iStart = 1
    while 1=1
    begin
        set     @iPos = charindex( @cDelimiter, @sString, @iStart )         
        if @iPos = 0                 
            set     @iPos = len( @sString )+1         
        if @iPos - @iStart > 0                                   
            insert into @tParts values  ( substring( @sString, @iStart, @iPos-@iStart ))         
        else                 
            insert into @tParts values( null )
        set @iStart = @iPos+1
        if @iStart > len( @sString )
            break
    end
    RETURN  
END