Link to home
Start Free TrialLog in
Avatar of mgferg
mgferg

asked on

merge - skip update if records > X

H All,

I'm doing a merge update/insert but want to verify that a condition doesn't exist before doing so i.e. the number of rows does not exceed a number e.g. 1000

so -
If the number of entries that will be updated/inserted from table a to table > 1000 send a specific message to the output

Some suggestions on best way to do this would be appreciated.

Thanks,
Mark
(newbie)
Avatar of mgferg
mgferg

ASKER

sorry small typo (missing table b)

It should read ...
so -
If the number of entries that will be updated/inserted from table a to table b > 1000 send a specific message to the output
...
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial