Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MrWombat
Starting Member
11 Posts |
 Posted - 2003-05-22 : 10:09:57
|
| Hi all i have this snippet of code that has an error Invalid Column Name PeetTot. Any ideas how i can get around thisCASE tblAgent.agt_Id WHEN 57 THEN tblFeesDue.fee_Amount ELSE 0 END AS PeetTot,CASE tblEstates.est_State WHEN 'VIC' THEN PeetTot ELSE 0 END AS PeetVic,CASE WHEN tblEstates.est_State <> 'VIC' THEN PeetTot ELSE 0 END AS PeetOtherCheers in Advance |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-22 : 10:30:00
|
| CASE WHEN tblAgent.agt_Id = 57 THEN tblFeesDue.fee_Amount ELSE 0 END AS PeetTot, CASE WHEN tblEstates.est_State = 'VIC' AND tblAgent.agt_ID = 57 THEN tblFeesDue.fee_Amount ELSE 0 END AS PeetVic, CASE WHEN tblEstates.est_State <> 'VIC' AND tblAgent.agt_ID = 57 THEN tblFeesDue.fee_Amount ELSE 0 END AS PeetOther --This could be simplified --You really only need PeetTot and PeetVic if PeetTot <> 0 then agt_ID = 57 and if PeetVic = 0 Then PeetOther would be fee_Amount |
 |
|
|
|
|
|
Cant reference an alias in a case statement