I'm reading the book Professional Sql Server Analyisis Service 2008 With MDX and I have encountred a strange use of the COALESCE function
SELECT * from Products where product_id >COALESCE(?,0) And
This query is found In page (881 of 1056). The authors trie to get data before last update. but what I personally know is that an expression is set instead of ?
I tried that above query and It gives me and error as I expected because ? makes no sens in my point of view, May does they mean that we put some expression there instead of ?. So the question is am I mising something if I use exactly the query without
modifying any syntax
The complexity resides in the simplicity
View Complete Post