insert into revenue (
Year,
Newsales,
Beginninginventory,
Purchases,
Goodforsales,
Endinventory,
Costofsales,
GrossIncome,
Salesandwages,
sss,
Rental,
Postage,
Lightandwater,
Freight,
Fuel,
Officesupplies,
Taxesandlicenses,
Representation,
Depreciation,
Transportation,
Repairs,
Miscellaneous,
Totaloperatingexpense,
Provisions,
Netincomefinal
)
VALUES (
@one,
(Select SUM(TotalPrice) FROM inventoryout where revenue.Newsales=@two),
@three,
@four,
@five,
@six,
@seven,
(select NewSales - Costofsales from revenue where GrossIncome=@eight),
@nine,
@ten,
@eleven,
@twelve,
@thirteen,
@fourteen,
@fifteen,
@sixteen,
@seventeen,
@eighteen,
@nineteen,
@twenty,
@twentyone,
@twentytwo,
@twentythree,
(select GrossIncome - Totaloperatingexpense from revenue where Netincomebeforetaxes = @twentyfour),
@twentyfive,
(Select Netincomebeforetaxes - Provisions from revenue where Netincomefinal = @twentysix)
)