I have an Excel file looks like this:
userid expense1 expense2 expense3
I import this into a temp table with MONEY data type, since it is a money type, the value for empty cell would be 0.
I need to update those values into database, only $10 and $20 will be updated, the values for empty cells will be be kept the same as wahtever database has now.
What would the best way to do this? thx