CREATE TABLE dbo.myTable

(

FieldA [INT],

FieldB [VARCHAR](5),

FieldC [INT],

)

And this failed...

INSERT INTO myTable (FieldA,FieldB,FieldC)

SELECT item from dbo.DelimitedSplit('1,2,3',',')

UNION ALL SELECT item from dbo.DelimitedSplit('A,B,C',',')

UNION ALL SELECT item from dbo.DelimitedSplit('10,20,30',',')

I am confused, I thought I did...

YES PLEASE

Yes I have, that deals with one column...

Ok first thanks to the forum for the function 'DelimitedSplit'

This is my next challenge..

I need to do an insert into a table

FieldA, FieldB, FieldC

From my three data strings like:

'1,2,3'

'A,B,C'

'10,20,30'

I...

Here is another tab split function that I pulled from a SQL 2000 book by Andrew Novick : Transact SQL UDFs

Which is better Lynns or Andrews ??? 😎

I gave it a go. I go the computed column working ok.

Buy I couldnt make it unique key or index as error message said ' something was not determinstic'...

How much overhead am I placing on a table with a computered column?

Will it slow inserts down much ?

..Try It..

I am but my TEST data set only allows 30 or so selections..

Are you saying you are not sure if it can handle 100+ selections????

Please dont be cyptic,...

Increase the size of the string.. I assume that means what I thought

String of different sizes

'1,2,3'

or

'1'

or

'1,2,3,5,6,7,9 ...etc to... 89,90,91,92'

So 92 IDs in the string, that would work also would it...

hang on..

I assume DelimitedSplit.txt can handle 1, 5, to 50 or 80 IDs at a time ??

Lynn nice code.. thanks:-D:-)

found a solution here

http://www.vbforums.com/showthread.php?t=402922

Thanks, well if I get 1000's of users, I will hire some one to advise me... until I am there ...thanks for your help !!

Signing off

Ok the last post makes sense...

.."Rebuild the clustered index periodically "...

I assume you mean the Primary Key identity field.

How is this done, rebuid a PK ? Do yo just remove...

Well dont hold back.. how do you re build a table , and re load records into a table that has a identity key...

I guess you just turn identity ...

To conclude..

I am going to use the simple Identity key as my main PK on all tables.

My delete process for a record (in all tables) is like this a field...