Click here to Skip to main content
15,895,142 members

Comments by Kris_C# (Top 7 by date)

Kris_C# 1-Jan-15 16:57pm View    
every think is ok, and my preposition is also good. But problem is when trigger upade data, becouse when I updata NET_WORTH_AF_DISCOUNT form query is work but when trigger do this, and another trriger used NET_WORTH_AF_DISCOUNT to updata NET_WORTH - there is null. I dont know why I tried sp_settriggerorder @triggername = 'NET_WORTH_ORDERS', @order= 'last', @stmttype= 'INSERT' or 'UPDATE' - but is not help
Kris_C# 1-Jan-15 11:46am View    
This not work,
I have two table ORDER and POSITION_ORDERS. One trigger update column POSITION_ORDERS.NET_WORTH_AF_DISCOUNT, another trigger must update ORDER.NET_WORTH when POSITION_ORDERS.NET_WORTH_AF_DISCOUNT is update by the first trigger. But I have all the time NULL. If any one know how to do it?
Kris_C# 29-Dec-14 5:39am View    
But I dont now what is wrong, for me is easy when NET_WORTH_AF_DISCOUNT is update by one trigger, next trigger see upadte and start update date in ORDERS.NET_WORTH
Kris_C# 24-Nov-14 10:42am View    
Ok, but I want configuration Reporting Servises in C# it is possible
Kris_C# 13-Nov-14 10:16am View    
and I dont see a posibility to add this reference.