Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag iif Rss

   Items 1 to 2 of 2   

MDX Performance - burdens of IIF

I used to think naively that IIF is an innocent little function that can only do good and help me...  Read more...
By aedna-843346 2011/02/16 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,534 reads

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.  Read more...
By Fred Simmons 2010/03/08 | Source: | Category: access
Rating: |  Discuss |   Briefcase | 7,673 reads
   Items 1 to 2 of 2   
access (1)    
analysis services (ssas) (1)    
blogs (1)    
dlookup (1)    
mdx (1)    
union (1)    
union all (1)