I have one field that holds a number composed for either '0' or '1' something like: 10010111101
I want to take the first digit and copy it to another field on a different table, then take the second digit and copy it to field number 2 of the other table and so on. There are 11 digits.
Table name with the 11 digits is: UserLogin
field in UserLogin table that has the digits: Accessrights
Table to which I want to copy the digits: contact_accessrights
The names of the fields in order is:
So the first digit should be copied to "Pprofile" , the second digit to "CGeneralInfo", etc.
There are also one to one fields I need to copy.
userid to userid ... same name in both tables and also firmid and userloginid ... three one to one fields.
Help is appreciated. Using MS SQL 2008.