T-SQL: Conver null or empty string to numeric value

I tried to use sum for a "varchar" type column in SQL table, and one day the code has error as there is a line contains empty value in this column and so the sum() function not working anymore.
So I add following function NULLIF(<clumn>,0)


The whole sum function is as below:
sum(CAST(NULLIF(AMOUNT,0) AS DECIMAL(22,2)))

Now I can get the sum amount value successfully.

Comments

Post a Comment

Popular posts from this blog

Top JavaScript courses helping you develop SPFx webPart with ReactJS and AngularJS

Image
As SharePoint 2016 is launched and the SharePoint Framework was announced on 4th of May,  for a SharePoint developer, these are the technologies that you should learn in the next months in order to be prepared to the new framework. They are AngularJS, ReactJS, Node.js and TypeScript. I shared those best online courses from "Udemy.com" in here. Learn anytime, anywhere, on most devices. Each course comes with a 30-day money-back guarantee. Course : Sharepoint: SPFx Development Model - It's providing clear instructions on this new SPFx framework. It delivers an example of full development workflow using Knockout.js JavaScript framework and PnP helper code. Instructor: OLEG RUMIANCEV is a full-time SharePoint ninja currently living in Biddulph, United Kingdom. His interests range from Microsoft and SharePoint to AI, and inspirational TED talks. ReactJS - React is straight JavaScript and more smaller compare with Angular JS. It's emerging in an ecosystem of...
Read more

Resolve error "AADSTS50012: Invalid client secret is provided" in MS Flow's HTTP connector

Image
I need to use HTTP connector in Microsoft Flow work flow to get the access token from SharePoint Online. I followed the article " Access SharePoint Online using Postman " to register the app and get the client id, client secret and tenant id. I composed the "body" section and added headers key to "HTTP" connector, and then submit the work flow by adding a new file to document library. However, it was failure with error "AADSTS50012: Invalid client secret is provided". Finally, I found out the issue is related to the none encode string of client secret value, and so I use "Variable" connector to save the client secret and other values, and used function "encodeUriComponent(...)" to encode the client secret value. The issue was gone and the HTTP call was successful to get the access token. The configuration of HTTP connector is as below screen shot. Courses for further study : Learn how to use Microsoft Flow and th...
Read more

React Native: buffer is not defined

Image
I tried to use "azure-mobile-apps-client" npm package in a React Native app, and it throws error "buffer is not defined" in Simulator. I searched around in google.com, and found out below solution: global.Buffer = global.Buffer || require('buffer').Buffer; var WindowsAzure=require('azure-mobile-apps-client'); I added above code to the .js file, and run it again. Done! the issue is gone and I can get the Azure Mobile App Service Client object which can be seen in the debug code in Chrome.     Run "npm i", and then run the app successfully. :) Further Study     I had been studied the online course " The Complete React Native and Redux Course ", it gave me the clear explanation and instruction with step by step procedures to learn the core knowledge to build React components for mobile devices. It's suitable for all levels. The course has sample code and completed projects in gitHub.com. Instructor : St...
Read more