Text to result set (and vice versa)?

microsoft.public.sqlserver.programming

1 Dec 2006 11:48 PM

Neil W.

I would like to create a Stored Procedure for breaking up a Text column into
a result set of one or more varchar(8000) rows. E.g., something like this:

CREATE PROCEDURE TextToRowset @TextColumnName TEXT AS ...

Where the result set would be one or more rows that looked like this:

CREATE TABLE breakitup (sequence INT IDENTITY, section VARCHAR(8000))

Does anyone have any tips on how to create this?

Many thanks.