need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

Can we use delete in merge statement?

0 Answers  

---

define sql delete statement ? : Sql dba

0 Answers  

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

What is sharding in sql?

0 Answers  

---

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

---

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

0 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

---

what is global table

7 Answers   iFlex,

---