Answer / 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 is the differnce between view and materialized view

4 Answers   TCS,

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

what is data control language? : Sql dba

0 Answers  

---

What is full join?

0 Answers  

---

Does a join table need a primary key?

0 Answers  

---

What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

How do I partition in sql?

0 Answers  

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

What sql does db2 use?

0 Answers  

---

Does inner join remove duplicates?

0 Answers  

---