J
Jay
Hi,
I'm fairly new to .adp's and have a stored procedure in which I have an
alias which performs a simple division calculation.
However, if the result is between 0 and 1 (i.e the two fields in the
calculation contain 500 & 700, so 500÷700 =0.71) my stored procedure
displays this as 0?
Can anyone advise how I get my alias field to display as decimal. Is there
some way to format the field in the SQL?
Any help greatly appreciated........Thanks, Jason
I'm fairly new to .adp's and have a stored procedure in which I have an
alias which performs a simple division calculation.
However, if the result is between 0 and 1 (i.e the two fields in the
calculation contain 500 & 700, so 500÷700 =0.71) my stored procedure
displays this as 0?
Can anyone advise how I get my alias field to display as decimal. Is there
some way to format the field in the SQL?
Any help greatly appreciated........Thanks, Jason