November 23, 2011 at 10:42 am
Hello,
Could you please help me regarding the update of two databases. I have two columns in excel. Column A contains email addresses. Column B contains invalid e-mail addresses. My aim is to delete all of the invalid e-mail addresses in Column A so that the valid ones would be unharmed, and would stay in the same rows as they were.
I want to use SQL Server 2008 to complete this task. I tried various queries, but I just can't make it work.
Thank you in advance for the help.
November 23, 2011 at 11:22 am
If you have already imported the data from Excel into SQL Server, it would help if you provided the DDL for the table you created (CREATE TABLE statement), some sample data (a series of INSERT INTO statements) that represents the problem you are trying to solve, the expected results based on the sample data, and what you have done sofar to solve your problem.
November 23, 2011 at 11:25 am
Please check: http://www.sqlservercentral.com/Forums/Topic493913-338-1.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply