This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Friday, September 20, 2013
Divide by zero SQL-server- NULLIF
Select qty/ NULLIF((select amt from amtfile where itemno=123),0) from itemqty
or user case when (select amt from amtfile where itemno=123) =0 then Null else select amt from amtfile where itemno=123) =0 end
No comments:
Post a Comment