I have a Visual Basic program that outputs a CSV file from my SQL database (for a software program).
The CSV file is generated for an LED sign.
The CSV file currently contains the item name and the current item price.
For example:
"Bud Light, 6.00"
We need to add an entry for the change in price, which is calculated as the current price minus the starting price. The starting price is a value in our SQL database.
For example, assume the starting price for Bud Light is $8.00, and the current price is $6.00.
The file will show:
Bud Light, 6.00, -2.00
I can show you the table in the SQL database that holds the starting prices for each item.
This should take 30 minutes or less.
Thanks