SQL SERVER – Dividing of Two Integer to get Float Value

if you make simple devide you will get integer without round value so you need to cast int to float Ex :

    SELECT (CAST(Number1)AS FLOAT)/Number1) AS AnswerFloat1

Comments

Popular posts from this blog

C# Crop white space from around the image

Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=xx.0.0.0, Culture=neutral, PublicKeyToken='xxx' or one of its dependencies.

The specified version string contains wildcards, which are not compatible with determinism.