Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Using Compute

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2009-08-18 : 06:17:40
Hello all,

Trying to get the sum of total number of pages at the end of a query. And get the value in to money.

So i need to charge a client 5.50 per page but it can't get it to work and looked on the web with no luck.
COMPUTE SUM(dbo.[Table1].[Pages] * '5.50' AS money)
   

- Advertisement -