Last modified by JShirley on Apr 22, 2010 4:21 AM. The ending inventory is 0. I find that in most cases, having a zero is graphically equivalent to NULL and a whole lot easier to deal with. ANSWER: I think there's an underlying issue here, which is that division by 0 is not legal. get redirected here
Therefore, running this code:
Enjoy Attached Thumbnails Reply With Quote Quick Navigation Microsoft SQL Server Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server In your solution, you have at least a NULL, which indicates that you cannot provide a correct result. Promoted by Recorded Future Do you know the main threat actor types?
The Coalesce replaces the resulting NULL by 0. –GuiSim Apr 16 '14 at 15:59 3 PLEASE! students who are have girlfriends/are married/who don't come in weekends...? To set a default value, we could use the ISNULL() or COALESCE() functions: