Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ebaydoug
Starting Member
15 Posts |
 Posted - 2003-10-10 : 14:53:39
|
| is there a way to build a table with a set of parameters and just pour data in..for example..i have a list of email addresses..i want to pour them in to a table that will remove duplicates, remove any field that contains .gov, .ebay, spam, unsubscribe, remove bad formats, info@ sales@ etc.. can i write the rules once and keep feeding the machine emails to filter?Thanks in advance!visit http://www.axzar.com today! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-10-13 : 11:45:44
|
God you're ambitious......and would you like it to fry your morning eggs as well.. in short no.but what you can do is break the whole process down into a series of smaller ones...which can come close to delivering the same result.define a temp table to hold all incoming/unvalidated emailsdefine a master table to hold all validated emails....put a 'unique index/constraint' on the email address.create a task to delete/reject undesirable emails addresses...i.e. as per your rules....if you wish you could make the 'rules' in data...by defining a rules table... which would be scanned before accepting/rejecting an addressie...rule number, type, validation contentrule 1, address, .govrule 2, address, .ebayrule 3, content, unsubscriberule 4, address, info@x.yrule 5, address, spammername@a.b.cbad formats....are more difficult to track...there have been some guidelines posted here about them....but they keep changing, so it may be hard to stay 100% on top of the problem.verifying the data automatically + continuously...is another problem...you may have to define how continuous you need the data validated...and maybe investigate running a program on a scheduler to keep in going non-stop.get the basics right....ie the 1st set above...and then the last bit should slot into place relatively easier. |
 |
|
|
|
|
|
|
|
Angels of Access Aweigh!