MS SQL

MS SQL RSS

seql 2000 Query returns wrong results

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Dec 2008

Posts: 42

Reputation: fawadkhalil is an unknown quantity at this point

Solved Threads: 0

fawadkhalil fawadkhalil is offline

Offline

Light Poster

seql 2000 Query returns wrong results

Apr 15th, 2009

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.

•

Join Date: Apr 2009

Posts: 217

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: seql 2000 Query returns wrong results

Apr 15th, 2009

CHANGE YOUR CODE IN THE BELOW WAY:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
Convert(decimal(10,1),(taxid*10.00)/100.00) AS tax
Convert(decimal(10,1),(taxid*10.00)/100.00) as tax