SQL Hardware Calculator
Jan 30, 2007Does anyone now of any tools available that can be used it properly spec'ing out Sql 2005 Database server based on transactions, querys and users?
View 1 Replies
ADVERTISEMENT
SQL Calculations Different Than On Calculator?
Jul 20, 2005I'm running SQL query to caluclate projected food costs. Thecalculation is this:(ReportedFoodSales / PlanFoodSales) * FullPlanFoodSalesSeems simple enough to me.Using the following numbers, SQL comes up with a different answer thanwhat I do with a calulator. The data types are money. I'm sure thereis some reasonable explanation....right?Reported Food Sales: 28096.4500Plan Food Sales: 28608.4167Full Plan Food Sales: 137702.0000SQL Answer: 135237.1342Calculator Answer: 135237.7308Any ideas?Thanks,Jennifer
View 3 Replies View RelatedYear To Date Calculator
Jul 27, 2006Does anyone know a script that will give the year to date? I'm doing a sales report and need to pull year to date information.
View 1 Replies View RelatedCalculation In Sql Sever That Match A Regulare Calculator
Aug 25, 1999hi, I want to make a calculation that have the result like a normal calculation, I know this has to do with the datatype I use,
declare @num int , @total int
select @num = 50/20
select @num
How can I have a result that do write any number to the right of the decimals. I guess this has to do with a datatype.... what kind of datatype that give me a control of how many decimals I want to view in the results.
Thanks
Ali