SELECT
	CASE WHEN Totalos > 0 THEN 0 ELSE (totalos-100) END AS Price
FROM
	dbo.database

quote:

---

Originally posted by jylland

hi I have problem

SELECT SUM(value) AS Totalos from tabel where ....

then I want validation of the Total

If Totalos > 0
then 0
else (totalos-100) end AS Price
FROM dbo.database
where......

But how do I do this with a case statement ?

---

Case When SUM(Values) > 0 then 0 Else SUM(Values)- 100 End

quote:

---

Originally posted by sunitabeck

SELECT
	CASE WHEN Totalos > 0 THEN 0 ELSE (totalos-100) END AS Price
FROM
	dbo.database

BTW, "database" is not really a good name for a table. If you do choose to use it, use it like dbo.[database]

---

quote:

---

Originally posted by sodeep

quote:

---

Originally posted by jylland

hi I have problem

SELECT SUM(value) AS Totalos from tabel where ....

then I want validation of the Total

If Totalos > 0
then 0
else (totalos-100) end AS Price
FROM dbo.database
where......

But how do I do this with a case statement ?

---

Case When SUM(Values) > 0 then 0 Else SUM(Values)- 100 End

Thanks very much great

---