0

i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group

3
Contributors
2
Replies
11
Views
4 Months
Discussion Span
Last Post by adam_k
0

Because you are not giving a lot of information, I cannot provide a specific solution.
Try to use a case when inserting or a trigger or use a stored procedure that handles this to insert .
Alternatively post your insert code, the db type and what is the program that will do the insert and we can probably help you to figure this out.

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.