July 27, 2018 at 6:58 am
Hi Experts,
Please help me to sort this - data is being inserted into a table and this table has a currency column.I want to get notified by email whenever the currency is in Russian ruble.
How can i work this out ?
Thanks in advance.
T
July 27, 2018 at 8:18 am
I've not had to solve this sort of problem, but my initial thought is to have a reference table with currency types. Use an IDENTITY INT column as the PK for this reference table and have a Description column with a string description of the currency, like "Ruble", "Pounds", " US Dollars", etc. When the currency value is entered you have a mechanism on the input where the currency description is recorded. Create an After INSERT trigger that checks the Currency Type and emails you if it corresponds to the Currency Type for Russian Rubles.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply