David,

Good suggestion on eliminating the .00 on items with no pennies, but I believe he wants it to round as opposed to truncating, which the convert will do without using...

Well, I could not find any documentation on the minimum scale of 6 on a multiplication of 2 decimal values, but it makes logical sense that you would not want...

Hi Chaz,

I finally came across the answer to this question.  Don't know if it is too late or not, but here it is:

declare @i numeric( 12, 4)

select @i = 6582321.6075

SELECT...

Hi Wangkhar,

   The answer is in the precision of the results being over 38 (p1+p2+1 on multiplication).  When you have large numbers multiplied, the results may be higher than what fits...

Try using the STR function such as this:

declare @i numeric( 6, 4)

select @i = 1.6075

select @i, str(@i, 6, 2)

What about using a max(col2) in the subquery instead of top 1?  That way you don't need an order by.