|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
March 30th, 2004, 04:27 PM
|
||||
|
||||
|
IF statement within a SELECT??? HELP?
I need to do an if statement within a select... I have basically this...
SELECT (If a price >200, enter value 'Expensive' into the column... else enter value 'Value') AS PriceType FROM ... Can someone convert that English to SQL? I've tried a few things, to no avail, and would prefer not to create a view just to do this... Thanks!
|
|
#3
March 30th, 2004, 05:45 PM
|
||||
|
||||
|
Code:
select case when price > 200
then 'Expensive'
else 'Value' end as PriceType
from ...
|
|
#4
March 30th, 2004, 05:53 PM
|
||||
|
||||
|
SELECT A.Name, A.Gender, SA.SalePrice AS Price, (SELECT CASE SA.SalePrice > 200 THEN 'Expensive' ELSE 'Value' END) AS PriceType
FROM Animal A, SaleAnimal SA WHERE A.AnimalID = SA.AnimalID AND A.Category = @BCategory AND A.Breed = @breed ORDER BY A.Name ASC Is this right? Still not working properly...
|
|
#5
March 30th, 2004, 06:18 PM
|
||||
|
||||
|
Code:
select A.Name
, A.Gender
, SA.SalePrice as Price
, case when SA.SalePrice > 200
then 'Expensive'
else 'Value' end AS PriceType
from Animal A
inner
join SaleAnimal SA
on A.AnimalID = SA.AnimalID
where A.Category = @BCategory
and A.Breed = @breed
order
by A.Name asc
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > IF statement within a SELECT??? HELP? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
