Split Column

Here is a sql query to split a single column to different multiple column.
CREATE TABLE Sample
(ID INT ,FullName VARCHAR(100))
----------------------------------------
INSERT INTO Sample(ID,FullName)VALUES (1,'Bheeshma,Nayak')
INSERT INTO Sample(ID,FullName)VALUES (2,'Himanshu,Mishra')
INSERT INTO Sample(ID,FullName)VALUES (3,'Ketan,Saxena')
-----------------------------------------
CREATE PROCEDURE Separate_Column
AS
BEGIN
CREATE TABLE #TEMP( FullName VARCHAR(100),
Fname VARCHAR(20),
Lname VARCHAR(20)
)
DECLARE @FullName AS VARCHAR(100)
DECLARE @Fname AS VARCHAR(20)
DECLARE @Lname AS VARCHAR(20)
DECLARE @RC AS INT
DECLARE @I AS INT
SET @I=1SELECT @RC=COUNT(1) FROM Sample
WHILE @I <= @RC
BEGIN
SELECT @FullName=FullName FROM Sample WHERE ID=@I
SET @Fname=LEFT(@FullName,CHARINDEX(',',@FullName)-1)
SET @Lname = RIGHT(@FullName,LEN(@FullName,CHARINDEX (',',@FullName))
INSERT INTO #TEMP VALUES(@FullName,@Fname,@Lname)
SET @I=@I+1
END
SELECT * FROM #TEMPDROP TABLE #TEMP
END
-------------------------------------------------------------
Note:-Next Post will Describe DotFuscator
-------------------------------------------------------------

Thanks & Regards
Bheeshma P. Nayak