I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Can be done in a stored procedure, or (more easily) in an application
language.
PB
-----
Khai Doan wrote:
I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Thanks!
Khai
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.37/2130 - Release Date: 05/23/09 07:00:00