Guess Email Address - Bulk Update

Hi

I have a table full of contacts and it stored data like:

Contact_ID | Firm_ID | First_Name | Last_Name | Email_Address

Some email addresses are null or blank for whatever reason. What I am trying to do is to guess the Email Address by analysing other contacts tagged to the same firm and enter this into the database

So if there is some one who has an email address like first_name.Last_Name@Company.com and belongs to firm id 0f 140, then any contacts that have no email address should be updated with an email address in this format as we are guessing that most email addresses at this company are goin to be in the same format.


Problem is I am not sure how to write the SQL. Any ideas??

Thanks in advanced
Start Free Trial