NewUsers is a table (in the ASPNET.mdf) has UserName, Password, Email 3 fields.
I¡¦d like to copy all the data in NewUsers to the following tables
It should be
1. NewUsers.UserName => aspnet_users.UserName
2. NewUsers.Password => aspnet_membership. Password
3. NewUsers.Email => aspnet_membership.Email
4. and setting the newsletter <SubscriptionType> to ¡§Html¡¨ in the aspnet_Profile table
How to do it? With store procedure or need C# /VB