Happy to have waited to be able to help you .

Ya that can be a problem .

Will have to look for his reply first .

Have you read this ?? Charindex is the slowest solution for this type of problems :

Arrays and Lists in SQL Server

Why not leave the view there?? You might screw up the system if you don't delete the right one.

Please post the table definition, some sample data and the expected results so we can help you.

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=197237

Select into can cause system tables locks in tempdb while the data is inserted, this can literally destroy the apllication. I'd stay far away from this.

That should be it... Do you get an error when executing this?

Maybe if you could post the query you used to get these results, we could help more :

Select Left(O.Name, 20) as OName, Left(C.Name, 20) as CName, C.id, C.XType from...

That's nice but how about we show him how to use the set based approach that he obviously doesn't know??

Let's go the other way around.

Create a new dts package, add an activex task, then switch the code to vb, then just insert this code and save, don't forget to...

Post the table definition, some sample data and the expected output from the query. We can't help you without that.

Forgot to include this part :

--I use this table for many other string operations as well

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY...

Check out this split code, just make a function out of it. Just do select Distinct EachId from dbo.fnSlip('1,2,3', ',')

Declare @vcDelimiter varchar(3)

Declare @IDs varchar(8000)

SET @IDs = '31,5,7,9,12'

SET @vcDelimiter =...