View Full Version : TSQL issues

01-07-2008, 02:27 PM
I have been operating from MS Access and have now upgraded to MS SQL 2005, in Access i could use a IIF Function in the creation of a veiw, in 2005, the function is there but it appears that it is only available to MDX queries, is this assumption correct and if not, what is the syntax for the function.