ColumnName | DataType |
Currency | varchar(50)
PreviousValue | decimal(18,9)
Change | decimal(18,8)
There is not Identity or any restriction.
Now I need someone to create a store procedure for insert Command
Step1: Check for that Currency Previous Value Exist
if Yes: Then Get the previous Value sorted by DateTime desc and store in variable
if No: Then previous value is 0
Step2: Create a variable with this formula
Percent= (@Previous- @CurrentValue)*100 / @CurrentValue
@CurrentValue is coming as In parameter
15 freelancere byder i gennemsnit $18 på dette job
Create a MySQL procedure to handle insert functionality. Relevant Skills and Experience MySQL, Stored Procedure, Database Programming Proposed Milestones $10 USD - Complete Stored Procedure
need to create a stored procedure to fulfill the client requirement Relevant Skills and Experience MySql Proposed Milestones $20 USD - better to work with fixed price
I write SQL stored procedures for a living, I can assure you this will get done correctly and efficiently. Relevant Skills and Experience SQL Server Management Studio Stay tuned, I'm still working on this proposal.