Advertisement
Advertisement
| 03.25.2008 at 08:26AM PDT, ID: 23267339 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: |
SELECT
CASE
WHEN Volumes > 0 AND Volumes <= 100 THEN 7.6
WHEN Volumes > 100 AND Volumes <= 500 THEN 8.6
WHEN Volumes > 500 THEN 9.0
END AS Rate,
Volumes
--need a [Rate] * [Volumes] AS [Total] type of column here.
FROM
Transactions
WHERE
ID = @ID
|