Need to create a Stored Procedure in SQL SERVER
Budget: ₹600 – ₹1,500 INR
1. Getting the records related to the changes in Order Type from Per_Auftr_Historie table.
2. Using Kundennr, find the related data from Per_Auftr table.
3. Check for 'revenue' and 'transaction' in "Status" Field of Per_Auftr table.
4. Create a new SP, Check for Status. Depend on Status, Trigger 2 SP.
2. Using Kundennr, find the related data from Per_Auftr table.
3. Check for 'revenue' and 'transaction' in "Status" Field of Per_Auftr table.
4. Create a new SP, Check for Status. Depend on Status, Trigger 2 SP.