DECLARE @n1 int
SELECT @n1 = n1*1.2 FROM YourTable
SELECT n1, @n1, @n1 + n1 * 0.8
FROM YourTable

quote:

---

Originally posted by Skorch

DECLARE @n1 int
SELECT @n1 = n1*1.2 FROM YourTable
SELECT n1, @n1, @n1 + n1 * 0.8
FROM YourTable

Some days you're the dog, and some days you're the fire hydrant.

---

quote:

---

Originally posted by KlausEngelInc

I'm trying to compute several values on the fly. How can I create a temporary variable to use in my query?

SELECT n1, (n1*1.2), (n1*1.2) + (n1*0.8)
FROM TABLE

I would like to establish the computed value of (n1*1.2) as a variable so I can continue to use it through the rest of my query. ANy help is appreciated.

---

quote:

---

Reliable only if it has single row

Madhivanan

Failing to plan is Planning to fail

---