<div>
To be more complete - you could use the first function like this:<br />
<br />
INSERT INTO MyTable (MyField)<br />
SELECT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data <br />
FROM dbo.Split('322,992,124,643<wbr />,233', ',')<br />
<br />
HTH
</div>


To be more complete - you could use the first function like this:

INSERT INTO MyTable (MyField)
SELECT      Data
FROM dbo.Split('322,992,124,643,233', ',')

HTH

<div>
Hi bdietz,<br />
<br />
another option is to use dynamic sql <br />
<br />
EXEC('Insert into urTable (UrColumn) &nbsp;SELECT &nbsp;'+@AboveString +'')<br />
&nbsp;<br />
<br />
Aneesh R!
</div>


Hi bdietz,

another option is to use dynamic sql

EXEC('Insert into urTable (UrColumn)  SELECT  '+@AboveString +'')
 

Aneesh R!

<div>
I would also use the function suggested by pootle_flump, as it protects against sql injection, and is more readable also.
</div>


I would also use the function suggested by pootle_flump, as it protects against sql injection, and is more readable also.

<div>
<div class="content wysiwyg-content">
I have a string such as:<br />
<br />
322,992,124,643,233<br />
<br />
being passed from an ASP form to a ms sql stored procedure. &nbsp;i want too pull out each number and insert them into the same column, but different rows<br />
<br />
322<br />
992<br />
124<br />
643<br />
233<br />
<br />
How can i do this? &nbsp;THanks
</div>
</div>


I have a string such as:

322,992,124,643,233

being passed from an ASP form to a ms sql stored procedure.  i want too pull out each number and insert them into the same column, but different rows

322
992
124
643
233

How can i do this?  THanks

How do i unconcatenate a string in SQL?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.