August 1, 2019 at 11:21 am
Hello,
I'm very new and have no experience in SQL reporting services, SQL trigger.
So, if possible, keep it simple JJ
This is what I want but I don't know what the best method is for getting this result.
Reporting services, trigger, ...... ????
Note : Table 'Orders' is a table where it's not possible for the ERP developers to check the value. (to do the check in the front end)
Description :
There is a SQL table 'Orders'. This table has a lot of fields.
When a new record, automatically, is created in the file then I want to test :
Has field "Type" the value 02 and is calculation : 1-((pur_price/qty_pur)/(val_pur/val_qty)) >0,10 of <-0,10 then a mail has to be sent to xxx@xxx.com
All the fields are in 1 record. So no check to other record.
Table structure :
Count | Type | Pur_price | Qty_pur | Val_pur | Val_qty | ......
125 02 15 10 52 5
Now a mail has to be sent.
I hope the picture is clear and that somebody can help me.
August 1, 2019 at 1:00 pm
"I hope the picture is clear and that somebody can help me."
not quite so far
"When a new record, automatically, is created in the file then I want to test"
what file do you mean?
how many records are in the table Orders?
" ((pur_price/qty_pur)/(val_pur/val_qty)) >0,10 of <-0,10"
of = OR or AND ?
Do you mean the following ?
-0.1<((pur_price/qty_pur)/(val_pur/val_qty))>0.1 ?
"All the fields are in 1 record. So no check to other record."
Can't get this verbal formula. Please, clarify.
August 1, 2019 at 1:35 pm
This post appears to be a duplicate of
https://www.sqlservercentral.com/forums/topic/mail-when-value-of-field-or-paramater
Which already contains suggestions (and some outstanding questions) as to how you might approach this.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
The topic ‘reporting services or trigger of ??????’ is closed to new replies.