Hello,
I am trying to write an update query which will flag a record if it meets a certain condition.
Here is what I have so far, we have a list with adressees, and we have more then one addressee per address. I've done a count procedure and its showing me that i have 2,368 that only have one match record, 518 that have 2 addressees, 194 - 3, 89 -4 and so on and on.
My question is based on this, is there a way to flag all the once upto say 4 and leave out anything with more then 4 addressees?
Or can I pickup only one record out. from each?
I've tried using the Deduplication procedure, but is not working for me! If someone can guide me on how to do this by an sql it will be most welcomed.
Thanks
I am trying to write an update query which will flag a record if it meets a certain condition.
Here is what I have so far, we have a list with adressees, and we have more then one addressee per address. I've done a count procedure and its showing me that i have 2,368 that only have one match record, 518 that have 2 addressees, 194 - 3, 89 -4 and so on and on.
My question is based on this, is there a way to flag all the once upto say 4 and leave out anything with more then 4 addressees?
Or can I pickup only one record out. from each?
I've tried using the Deduplication procedure, but is not working for me! If someone can guide me on how to do this by an sql it will be most welcomed.
Thanks