DECLARE
@Str
nvarchar
(
1000
);
DECLARE @Index int ;
DECLARE @Left nvarchar ;
SELECT @Str = ' A,B,C ' ;
WHILE CHARINDEX ( ' , ' , @Str ) > 0
BEGIN
SELECT @Index = CHARINDEX ( ' , ' , @Str );
SELECT @Left = LEFT ( @Str , @Index - 1 );
INSERT INTO Table1 (A1) VALUES ( @LEFT );
SELECT @Str = REPLACE ( @Str , @Left + ' , ' , '' );
END
IF @Str <> ''
BEGIN
INSERT INTO Table1 (A1) VALUES ( @Str )
END
DECLARE @Index int ;
DECLARE @Left nvarchar ;
SELECT @Str = ' A,B,C ' ;
WHILE CHARINDEX ( ' , ' , @Str ) > 0
BEGIN
SELECT @Index = CHARINDEX ( ' , ' , @Str );
SELECT @Left = LEFT ( @Str , @Index - 1 );
INSERT INTO Table1 (A1) VALUES ( @LEFT );
SELECT @Str = REPLACE ( @Str , @Left + ' , ' , '' );
END
IF @Str <> ''
BEGIN
INSERT INTO Table1 (A1) VALUES ( @Str )
END