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.

CHANGE YOUR CODE IN THE BELOW WAY:

Convert(decimal(10,1),(taxid*10.00)/100.00) as tax

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.