I'm faced with a challenging task. I wonder if someone could guide me on how
I can accomplish it.

I have a view in a database - A
I need to update the records of this view based on the another similar table
which sits in another database (B1) of another instance. Update's set to all
other columns in A is only done if the Field PODNo of A matches the PODNo of
B1.

How can I accomplish this. Can stored procedure do the job?

If I were to code it in VB.Net,
How do I store my B1's records into an arraylist then using this arraylist,
populate my A table?