same columns multiple rows

Question

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

Shakti Singh Dulawat · Answer

Please mark this thread as answer and for new questions please open new thread.

Karthik G · Answer

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 Dulawat · Answer

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

same columns ,multiple rows