Problem during insert data from one table to the other

BeginINSERT Into aspnet_Membership (ApplicationId,UserId,Password,PasswordFormat,PasswordSalt,Email,LoweredEmail,IsApproved,IsLockedOut,CreateDate,LastLoginDate,LastPasswordChangedDate,LastLockoutDate,FailedPasswordAttemptCount,FailedPasswordAttemptWindowStart,FailedPasswordAnswerAttemptCount,FailedPasswordAnswerAttemptWindowStart)Select'{FB1DA11C-F1AB-4E42-AAFE-E9EC8D6C607F}',UserId, cast(Rand() as nvarchar),0,'0',UserEmail,UserEmail,1,0,getdate() ,getdate() ,getdate() ,getdate() ,0,'01/01/1754',0,'01/01/1754'From aspnet_UsersEnd

the problem is the Password field i try to insert to every record other password, but it give me at first a random numbers but it appear at all of the records...

what can i do that each record will get a random password?

Thanks

You can declare a cursor on aspnet_users and step through each record inserting as you go.

|||

The built-in Rand() function will not work. You can try a user defined user_Rand() function to get the random seed each time.