Variable
Take the total amount lost (#4) and subtract it from Total profit ($45,000) and store that number
September 8th, 2015 4:13am
Means 45-4=41 and store in the database?
Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 4:32am

To store it in a variable:

DECLARE @NetProfit DECIMAL (15,2);
SET @NetProfit = @TotalProfit - @TotalLoss;
To store it in table, requires INSERT or UPDATE.

September 8th, 2015 5:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics