How do I transfer Excel from one computer to another w/o installation CD?

Question

I have a sales table which contains (product code, quantity, unitprice...) and I want to calculate the amount for each product code but I have some free product in with I want to have the amount to be 0

How can I do it with SQL?

This is the idea of what I'm expecting

CASE
    WHEN freegoodline = 0 THEN
        AMOUNT = SUM(B.QUANTITYB.UNITPRICEB.VAT1RATE) OVER(partition by B.PRODUCT_CODE, B.sinvoice_code)
    ELSE
        AMOUNT = 0
END

Solution

You can't simply copy the installed program over.

1. Use ProduKey to recover your Office/Excel 2010 key.

2. If you don't have the installer download the matching version of Office using these official links.

3. Use key to activate Office/Excel on new PC.

4. Uninstall Office/Excel from old PC.

Comments

[jarlh]

Show us some sample table data and the expected result - all as formatted text, not images. (minimal reproducible example)

[deHaar]

How have you tried to do it? Can you show us your effort?

[Gordon Linoff]

If the product is "free" what is the unit price?