IIF Function into SQL Server

[kingz2000]

Hi,

I have a query which works in access and contains the IIF function. Is there a way around this function in SQL-Server??

Could I, theretically, create a function IIF which works in the same way??

Thanks in advance ofr your help

 

[dhookom]

SQL Server supports the CASE WHEN... expressions. Check books on line for specifics or come back with your IIf() for someone to convert for you.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kingz2000]

I am able to make the 'select' work...it takes 90 seconds..but when I try to create the view it gives me 'timeout expired'...

what now?

 

[dhookom]

You either provide more information so someone can help or you live with your existing condition.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kingz2000]

To elaborate,
I have a group by sql-statement which takes 90 secs to produce my results, since the tabels are very large. when I create a view with it, I get an error message when I try to get the results. The error message reads 'Timeout expired'!

Is there anyway i can get the view not to give up so easily..Similarly to the select execution I would wait 90 secs.

I don't really know what info you require. The sql statement is simply select x from y group by ...

Thanks in advance

 

[dhookom]

If this is a SQL Server query than it would be best to ask questions in a different forum. If this is an Access question, you should provide some information about your query such as the SQL view, ODBC Timeout value, which fields are indexed,...

Duane MS Access MVP
Now help me support United Cerebral Palsy