umm sorry did not actually solve my prob
it outputs 0x4429BDEEB9E472EC1CAC4608024A7C7E
but i only want 4429BDEEB9E472EC1CA
dont need the 0x at the beginning and only need the first 19 chars
and also i want it to save the output directly into the column
The column you are inserting into has an index with a unique constraint. Either rethink your database design or remove the constraint. To remove the constraint, Under indexes, open IX_UserInfoUserID and uncheck the unique checkbox.
is there no way to do it like this then?
there is a userID w/c is unique to individual aacounts
like insert into table column where userid=userid
i dont know that much about how it works...
what i did is i made a copy of the database so that the source and destination will be diff