Round off difference - Sqlserver

[FRBhote]

The statement

SELECT PTY, CITY, ROUND(PEAK *.5, 2), PEAKADJ
FROM U1.Z1
WHERE PEAKADJ > ROUND(PEAK * .5, 2) AND PTY = '32S1'

Gives 2024850.840 in Sqlserver Management Studio, but gives 2024850.83 in TD.

Why would this happen?

x.png

[FRBhote]

Same problem with TD 7.

[thomas.uttendorfer]

Hi,
have you tried to replace :nFactor through 0.5 ?

Code: Select all

@ROUND(PEAK * .5, 2)

instead of

Code: Select all

@ROUND(PEAK * :nFactor, 2)

?
Regards Thomas

[FRBhote]

Tried that - no difference:

!!CB!! 174
Set sSelect = "SELECT CITY, MARGINADJ, ( (PEAK* " || SalNumberToStrX( nFactor, 2 ) || ") ) - PEAKADJ
INTO :sCityCode, :nSpanMarginCollected, :nPeakShort
FROM " || sgSchema || "Z1
WHERE PTY = :sPartyCode AND CITY = :sCityCode AND PEAK - PEAKADJ > 0"
-------------------------
Evaluates to:
String: SELECT CITY, MARGINADJ, ( (PEAK* 0.50) ) - PEAKADJ
INTO :sCityCode, :nSpanMarginCollected, :nPeakShort
FROM U1.Z1
WHERE PTY = :sPartyCode AND CITY = :sCityCode AND PEAK - PEAKADJ > 0