Would you be able to set a flag field for each kind of anomaly in your load script ?
Depending on your precise needs you should be able to do in one pass of the data :
If ( [YourField] = 'anomaly1' , 1 , 0 ) [Anomaly 1 Flag] ;
If ( [YourField] = 'anomaly2' , 1 , 0 ) [Anomaly 2 Flag] ;
Best Regards, Bill Markham
I do not think that would be possible or practical, I am looking at about 10 databases, with millions of records and I can list right away at least 10-15 complex selection queries most of which are calculated.
Just reloading this database takes a lot of time.
I need something more practical; think of invoice database (hader plus item list); I want to compare if item which shows on the list of original invoices have comparable item in another database (ie. research database) and then I want to compare if quantity or packagiing is same or not. If everything either fit or not, then I flag this whole invoice in order to see how many invoices will be flaged, which sales people have more then usual amount of flags and so on...
You can also try using alternate states. See this tutorial for an example that sounds similar to your requirements: Using Alternate States to Select Multiple Values in a List Box with Different Attributes