IIF equivalent

[LLBP]

Is there a way to use IIF or the like to perform aggregate function based on the value of another column?

I use this successfully in Access:
IIF([Department]=80, SUM([Uptime]), MAX([Uptime]))

I get an error about IIF not being recognized when using it in an expression in a view in SQL Server 2000. If I try it in Query Analyzer I get an error about "=" is invalid expression.

Any help is appreciated!

Brent

 

[SQLDenis]

untested

CASE [Department]when 80 then SUM([Uptime]) else MAX([Uptime]) end

but since you didn't provide DDL and DML you are on your own to test this

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[LLBP]

Outstanding! Thanks.