CREATE table #table (id int,contents varchar(max),val varchar(max))
insert into #table 
select 1,'a b c d','1 2 3 4' union all 
select 1,'a b d','1 2 4' union all 
select 2,'a b c d','1 2 3 4'

DECLARE @tbl AS TABLE( id int, Contents Varchar(MAX), Val Varchar(MAX) )
DECLARE @id int, @Contents AS VARCHAR(MAX), @Val AS VARCHAR(MAX)

DECLARE cur CURSOR
FOR SELECT ID, Contents, val FROM #table
OPEN cur
FETCH NEXT FROM cur INTO @id , @Contents , @Val 

WHILE @@FETCH_STATUS = 0
BEGIN
	
	INSERT INTO @tbl 
	SELECT @id, a.strdata, b.strdata FROM
	( SELECT strdata , ROW_NUMBER()OVER (ORDER BY strData) Seq FROM SplitText(@Contents, ' ') ) a
	INNER JOIN 
	( SELECT strdata , ROW_NUMBER()OVER (ORDER BY strData) Seq FROM SplitText(@Val, ' ') ) b
	ON a.seq = b.seq
	
	FETCH NEXT FROM cur INTO @id , @Contents , @Val 
END 
ClOSE cur
DEALLOCATE cur

SELECT * FROM @tbl

CREATE FUNCTION [dbo].[SplitText]
                    (@list      ntext,
                     @delimiter nchar(1) = N',')
         RETURNS @tbl TABLE (--listpos int IDENTITY(1, 1) NOT NULL,
                             --nstr    nvarchar(2000) ,
 									  strData varchar(4000)) AS

   BEGIN
      DECLARE @pos      int,
              @textpos  int,
              @chunklen smallint,
              @tmpstr   nvarchar(4000),
              @leftover nvarchar(4000),
              @tmpval   nvarchar(4000)

      SET @textpos = 1
      SET @leftover = ''
      WHILE @textpos <= datalength(@list) / 2
      BEGIN
         SET @chunklen = 4000 - datalength(@leftover) / 2
         SET @tmpstr = @leftover + substring(@list, @textpos, @chunklen)
         SET @textpos = @textpos + @chunklen

         SET @pos = charindex(@delimiter, @tmpstr)

         WHILE @pos > 0
         BEGIN
            SET @tmpval = ltrim(rtrim(left(@tmpstr, @pos - 1)))
            --INSERT @tbl (str, nstr) VALUES(@tmpval, @tmpval)
				INSERT @tbl (strData) VALUES( @tmpval)	
            SET @tmpstr = substring(@tmpstr, @pos + 1, len(@tmpstr))
            SET @pos = charindex(@delimiter, @tmpstr)
         END

         SET @leftover = @tmpstr
      END

      --INSERT @tbl(str, nstr) VALUES (ltrim(rtrim(@leftover)), ltrim(rtrim(@leftover)))
		INSERT @tbl(strData) VALUES (ltrim(rtrim(@leftover)))	
   RETURN
   END

quote:

---

Originally posted by vaibhavktiwari83

How do you know person is SHE

---

quote:

---

Originally posted by DBA in the making

quote:

---

Originally posted by vaibhavktiwari83

How do you know person is SHE

---

Because Vikky is a girl's name.

There are 10 types of people in the world, those that understand binary, and those that don't.

---

quote:

---

Originally posted by vaibhavktiwari83
Go to his profile his name is vikrant and in india vikky is name of boy not a girl

---