12-26-2016 1:24 PM - edited 02-03-2024 6:25 PM
Hi Everyone,
We have a query.
We have the source table data in which has a column 'valid from' .
e.g
the output it should compare the records in the tables and populate valid till in the column just one day before of next the record which exists in the table for the same exchange rate ,currency and inf1 combination. For the last record, it should populate 31.12.9999
Please let me know if which scenario to use( CV with SQL or procedure)?
We cannot create a new table here as per restriction and therefore need to look for other solutions.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.