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.

Recommended Answers

All 2 Replies

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.