Answer Posted / gopi muluka

DECLARE @STR VARCHAR(50),
@Char VARCHAR(10),@N INT, @CNT INT
DECLARE @TAB TABLE (VAL VARCHAR(30), CNT INT)

SET @STR='A,B,C,D,E,F,C,A,S,K,C,B'
SET @CHAR=''
SET @N=1
SET @CNT=1
WHILE @N>0
BEGIN
PRINT @STR
SET @CHAR=SUBSTRING(@STR,1,CHARINDEX(',',@STR)-1)
IF NOT EXISTS(SELECT 1 FROM @TAB WHERE VAL=@CHAR)
INSERT @TAB VALUES (@CHAR,@CNT)
SET @STR=SUBSTRING(@STR,CHARINDEX(',',@STR)+1,115)
IF CHARINDEX(@CHAR,@STR)>0
BEGIN
UPDATE @TAB
SET CNT=CNT+1
WHERE VAL=@CHAR
END
SET @N=CHARINDEX(',',@STR)
PRINT @N
END
SELECT * FROM @TAB

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1538

---

What is Materialized View? In What Scenario we Use Materialized View?

9401

---

What is the mutating table and constraining table?

970

---

What is index example?

955

---

What are the subsets of sql?

1038

---

define sql insert statement ? : Sql dba

977

---

How many joins can you have in sql?

881

---

Explain the difference between sql and mysql.

1003

---

What is primary key and unique key?

1053

---

What is coalesce sql?

944

---

What is pl sql script?

979

---

how to delete an existing column in a table? : Sql dba

954

---

What are the usages of sql?

1014

---

What is update query?

922

---

what are local and global variables and their differences? : Sql dba

1010

---