Convert Access to SQL Server

[hariharanmca]

I am using IIF condition in MSAccess to split two kind of rows into column why it is not possible in SqlServer or how can i do.

[iburyak]

IIF is a VBA function and just recognized by Access.

Use case instead.

[PHP]Case when condition then result1 else result2 end[/PHP]

[dorinbogdan]

In queries, I use SQL Case method as an equivalent to IIF:

Case When (anyFlag <> 0 ) Then  ... Else ...End

For more investigation, It may be helpful if include here some MSAccess sample.

[hariharanmca]

In queries, I use SQL Case method as an equivalent to IIF:

Case When (anyFlag <> 0 ) Then  ... Else ...End

For more investigation, It may be helpful if include here some MSAccess sample.

Yes i already tryed that, but it wont run in Sql view

[dorinbogdan]

I know that a SQL View can contain Case statements.
For further investigation, it may be helpful if include here some of your MSAccess sample, and even the SQL View not working code.