Member Avatar for SRI SAI

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
  • 209 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for adam_k

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.