-
Tricky IIF convert to T-SQL
Hi,
at first my question i not a pure SQL question. It's more between MS Access and T-SQL.
I have to upgrade an MS Access database to Sql Server. I found a statement in a Access query which drives me crazy.
IIf(Left([A_Extraktion_PIB_Split].[Produkt],3)<>"LLD",IIf([Produktkategorie]="MM",IIf(Not IsNull([T_MM_Handelsmarkierung].[MarkDate])
How can I convert it to SQL ? Normally I would use a CASE WHEN construct, but here I'm lost.
Thanks a lot.
Schoofy
-
Is this nested IIF?. You can nest CASE upto 10 levels in SQL Server.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|