Perform Mathematical Calculations on Database Fields

This topic is locked

Perform Mathematical Calculations on Database Fields	4/25/2011 7:36:20 PM
ASPRunnerPro General questions
Lowkeck authorDevClub member Hi All, I have two tables in my MSSQL DB: dbo.SaaSPricing dbo.SaaSBilling I want to multiply columns from two seperate tables in ASPRunner Pro. For example: dbo.SaaSBilling.Base dbo.SaaSPricing.BaseCost dbo.SaaSBilling.Base dbo.SaaSPricing.BaseRetail I have tried a few methods, but none seem to work. Any ideas? Thanks, Jason


	Sergey Kornilov admin 4/25/2011
	Jason, I would suggest to check SQL Server manual for specific syntax you need to use. Take a look at this article just in case: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/188e2fbc-e0ba-4876-8a4a-1c04a15292b2/