same columns ,multiple rows

Karthik G

10y905SQL

my table structure is given bellow

deptid  ename

10      CLARK,KING,MILLER

20      ADAMS,FORD,JONES,SCOTT,SMITH

but i want the output sould be like

deptid   ename

10       CLARK

         KING

         MILLER

------------------

20       ADAMS

         FORD

         JONES

         SCOTT

         SMITH

please tell me how to do it in sql

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shakti Singh Dulawat10y ago
Accepted answer
Please mark this thread as answer and for new questions please open new thread.
Karthik G10y ago
thank you...i got proper answer.
i need one more help from your side...that is
Is it possible to write a SQL query/procedure to identify a complete list of a stored procedures dependencies? I'm only interested in identifying other stored procedures and I'd prefer not to limit the depth of nesting that it gets too either. For example, if A calls B, which calls C, which calls D, I'd want B, C and D reported as dependencies for A.
Shakti Singh Dulawat10y ago
I find all you want Converting a single comma separated row into multiple rows - See more at: http://sqljason.com/2010/05/converting-single-comma-separated-row.html