Insert multiple values

[abenitez77]

I have multiple values I want to insert into a table. I am building a query that will use parameters and I want to be able to insert multiple values.

table: users
column: username

parameter: @userlist

Set @userlist = 'bob,lucy,frank'

How can I insert these 3 users into users table using a query whithout knowing how many users will be added to the parameter userlist?

 

[abenitez77]

Like an array that I can loop thru?

 

[bborissov]

check FAQ for Split function.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[markros]

Check

http://www.sqlservercentral.com/articles/Tally+Table/72993/

PluralSight Learning Library

 

[abenitez77]

Thanks! worked like a charm. Great article.