Attching a large number of assets to workstations

Hi,

I have a large number of workstations configured in my installation of SD+ and an even larger number of assets which need to be attached to the workstations. I also need to fill in the serial number and asset number for some of these assets (which can be derived from the the workstations' details).

To use the GUI to do this bulk update would take forever, so I would like to write some SQL to do this. Could you please let me know which tables and fields need to be updated in order to attach workstations and assets, and which fields I need to pay particular attantion to in order to achieve my goal.

Thanks

Ray