List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 24 2009 2:17am
Subject:Re: Is it possible to convert column data into rows
View as plain text  
>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
>
>   

Thread
Is it possible to convert column data into rowsKhai Doan24 May
  • Re: Is it possible to convert column data into rowsPeter Brawley24 May