I need to write a script that creates will create login ID's based on the contents of a table. For the purpose here I will call the table newLogins, and I need to perform 3 actions for each row in this table using dynamic SQL. First I need to create a login with a temporary password based on the first four letters of the login name followed by 9999, secondly set the default database (for this I will use AP) and three I need to create a user for the login with the same name as the login and assign the users to the 'PaymentEntry' role.
I could really use some help here I am new to sql and absolutely brand new to Dyanmic SQL!
Create Table NewLogins
(LoginName varchar(128))
Insert NewLogins
Values ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers')