This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
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