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 |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2006-10-31 : 15:20:31
|
Hello Everyone,I have the following syntax:=IIf(Fields!Disposition.Value= 1, Fields!TMOLoanNbr.Value > 0) Sum( Fields!Disposition.Value) Is this correct?TIAKurt |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2006-10-31 : 16:07:37
|
| There is no IIF in SQL server. Go to the Transact-SQL reference section in the SQL book online and read the CASE topic, or just google CASE SQL"it's definitely useless and maybe harmful". |
 |
|
|
samuelclay
Yak Posting Veteran
71 Posts |
Posted - 2006-11-01 : 17:25:58
|
| looks like it could be reporting services report code. I think IIF syntax is :IIF( (condition),(result1),(result2) )not sure how that would match up with your code, you have 2 conditionalys seperated by a comma, and only 1 result. FYI, There is a reporting services section to the forums.. |
|
|
|
|
|
|
Help with Immediate IF