SQL Server Forums

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL View

New Topic

Reply to Topic

Printer Friendly

Author

Topic

sathyarangaraj
Starting Member

India
11 Posts

Posted - 09/25/2012 : 03:35:42

I need to calculate Expr3=Expr1 / Expr 2 in SQL view. I have posted my code below. I am getting an error "The query cant be parsed"

SELECT (EXPR2 / Revenue)*100 FROM
(
SELECT
EXPR2= (SELECT SUM(CAST(A.[Total revenue] AS MONEY)) FROM dbo.tbl_Final_BRIT_Data A INNER JOIN dbo.tbl_contextgrouping AS B ON A.SYS_ID = B.Partner_ID
WHERE (A.[Total revenue] NOT LIKE '%[^0-9]%') GROUP BY B.Group_name),
REVENUE= (SELECT SUM(CAST(A.[Total revenue] AS MONEY)) FROM dbo.tbl_Final_BRIT_Data A INNER JOIN dbo.tbl_contextgrouping AS B ON A.SYS_ID = B.Partner_ID
WHERE (A.[Total revenue] NOT LIKE '%[^0-9]%') GROUP BY B.Group_name)
) AS EXPR3
Thanks in advance

khtan
In (Som, Ni, Yak)

Singapore
16745 Posts

Posted - 09/25/2012 : 04:42:40

try

SELECT 	SUM(CAST(A.[Total revenue] AS MONEY)
	/ SUM(CAST(A.[Total revenue] AS MONEY) * 100
FROM 	dbo.tbl_Final_BRIT_Data AS A 
	INNER JOIN dbo.tbl_contextgrouping AS B 	ON 	A.SYS_ID = B.Partner_ID
WHERE 	(A.[Total revenue] NOT LIKE '%[^0-9]%') 
GROUP BY B.Group_name

KH
Time is always against us

sathyarangaraj
Starting Member

India
11 Posts

Posted - 09/25/2012 : 08:12:51

Thanks for your reply Khtan. I need to give condition in Expr2 as Total revenue <1000000
= sum(Total revenue<1000000)/sum(Total revenue) * 100 group by Group_Name

This one i cant do with your code