The following is the isql command which works
isql /S IMGTW011 /d ODR_DTEST /w600 /E /n h /s "|" /Q "exec upTransMinor91" /o d:\trans_Minor_91.out
The output for 2 fields in isql looks like
Interest Rate Unit_Prc/Div_Rt
0.071250 0.000000
The Output of the sqlcmd
SQLCMD /S IMGTW011 /d ODR_DTEST /w600 /E /n h /s "|" /Q "exec upTransMinor91" /o d:\trans_Minor_91.out
Interest Rate Unit_Prc/Div_Rt
7.1249999999999994E-2 0
The Precision of the above fields changed totally when i run it from isql & SQLCMD. I am running the same Stored Procedure in both places
The following is the Query which is in the Stored Procedure
Select "Interest Rate" = ISNULL(Interestt, 0.0),
"Unit_Prc/Div_Rt" = ISNULL (Per_Unit_Rt,0.0)
from Table
Not sure why this is happening. Any Help on this will be Greatly Appreciated