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 the advantages of sql ? : Sql dba

1136

---

What is the current version of sql?

1091

---

What is your daily office routine?

2334

---

what is dbms? : Sql dba

1053

---

Can delete statement be rollbacked?

1048

---

Is inner join faster than left join?

1271

---

Is primary key always clustered index?

1087

---

What is the current version of postgresql?

1153

---

what are aggregate and scalar functions? : Sql dba

1122

---

how to use regular expression in pattern match conditions? : Sql dba

1102

---

If a cursor is open, how can we find in a pl/sql block?

1234

---

how many tables will create when we create table, what are they? : Sql dba

1136

---

what is schema? : Sql dba

1127

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

---

Do we need to rebuild index after truncate?

1126

---