Member Avatar for fawadkhalil

Hi all
Convert(decimal(10,1),(taxid*10)/100) as tax

value in taxid is 1. And also im getting .0 result but it should return
.1
Plz help me..........why im getting wrong answer.

  • 2 Contributors
  • 2 Replies
  • 69 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by fawadkhalil
Member Avatar for mail2saion

CHANGE YOUR CODE IN THE BELOW WAY:

Convert(decimal(10,1),(taxid*10.00)/100.00) as tax
Member Avatar for fawadkhalil

wow that really works.
Thank u mail2saion

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.