I don't think you can use another Windows XP CD that happens to have XP SP2 on it to update to SP2 on a current installation. Maybe a repair install? I'm not sure.
The OS is unable to update? Do you have a legitimate Certificate of Authenticity with the product key? Or are you using XP illegally?