Thanks Mike. Opened up the procedure and gave it a look. It looks like there's some multiplication and division going on, which is resulting in a change. Relevant part for one of the returned values:
MemberPrice = (case when qp.productid is null then p.MemberPrice else case when qp.MemberPrice is null then p.MemberPrice*((100-qp.memberdiscountpercent)/100) else qp.MemberPrice end end) Running this query on ColdFusion 7.('current') against MS SQL returns (again, cfdump of the cfquery, and the same thing as SQL Studio returns): 0.00000000 On CF 8, we instead get: 0E-8 So, updated CF 8 SQL Driver perhaps? Either way, unless there's an Administrator change, this does mean we'll have to evaluate code since, right or wrong, CF 7 doesn't make this change. Thanks! ~James ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm