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

What are different functions in sql?

998

---

How to read/write files from pl/sql?

1085

---

What is sql and how does it work?

1252

---

Can primary key be changed?

955

---

what is not null constraint? : Sql dba

1078

---

What is a schema sql?

1228

---

What is the difference between the conventional and direct path loader? : aql loader

1195

---

What is trigger in sql and its types?

1113

---

Can triggers stop a dml statement from executing on a table?

1160

---

what are dynamic queries in t-sql? : Transact sql

1070

---

Inline the values in PL/SQL, what does it mean.?

1275

---

Is it possible to update views?

1007

---

What are the qualities of 2nf?

1097

---

How do you determine the current isolation level? : Transact sql

1206

---

Can I call a procedure inside a function?

1076

---