loop from the list

[peac3]

Hi guys,

just wondering whether you guys have any idea to loop from the list I have example like below :

@username = ('a','b')

Is there anyway to make the @username list become array1, array2 like other programming?

I know I can put them into table first but I dont wanna do it.

 

[peac3]

I think I need put additional information on this,

like I want to create user based on this list.

@username = ('a','b')

Create user 'a' with login 'a'
Create user 'b' with login 'b'

Thanks guys,

 

[simian336]

Perhaps you can show us your data and what you are trying to do...

Simi

 

[markros]

Can you explain what you're trying to do exactly?

In the meantime, you may want to read all times classic

Arrays & Lists in SQL Server

PluralSight Learning Library