elee1969 (7/17/2013)

---

Not sure if i am doing this correct but i get an error as i followed your advice. I attached a screenshot.

Luis Cazares (7/3/2013)

---

You can use a CASE statement.

SELECT q.Course_Code, CASE WHEN res.[4a] = 0 THEN 0 ELSE 6-res.[4a] END as [4a],

...

manikanta1207 (7/3/2013)

---

what is the query to select nth highest salary of emp table

like this:

SELECT q.Course_Code, 6-res.[4a] as [4a],6-res.[4b] as [4b], 6-res.[4c] as [4c], 6-res.[5a] as ,res.[5b],res.[5c],res.[6a],res.[6b],res.[6c],res.[7a],res.[7b],res.[7c],res.[7d],res.[7e] as converted

FROM

like this:

SELECT q.Course_Code, 6-res.[4a] as [4a],6-res.[4b] as [4b], 6-res.[4c] as [4c], 6-res.[5a] as ,res.[5b],res.[5c],res.[6a],res.[6b],res.[6c],res.[7a],res.[7b],res.[7c],res.[7d],res.[7e] as converted

FROM

Eugene Elutin (7/3/2013)

---

just replace first line of your SELECT query to:

SELECT q.Course_Code, 6-res.[4a] as [4a], 6-res.[4b] as [4b], 6-res.[4c] as [4c], 6-res.[5a] as [5a] ... etc.

Eugene Elutin (7/3/2013)

---

6 - X formula will work for you:

SELECT v, 6-v as converted_v

FROM (VALUES (1),(2),(3),(4),(5)) v(v)