Hi Chris,

If I write the query as

SELECT GroupName, ElementName, 0 AS UserCount

FROM (

SELECT g.GroupName, e.ElementName, USERID

FROM tbl_MVTResult r

LEFT JOIN tbl_MVTElement...

The query I am using now is

SELECT GroupName, ElementName, COUNT(*) AS UserCount

FROM (

SELECT g.GroupName, e.ElementName, USERID

FROM tbl_MVTResult r

LEFT JOIN tbl_MVTElement...

Hi Chris,

I needed some help. The query you had given worked good, but 1 small problem I am having. From your query we can see that By groupName which...

In my report I am also showing the percentage of each element clicked. Before I was running one SQL to find out how many visits were there for per group....

Hi Gail,

Sorry to bother you. Wondering if you could find some solution. Thanks for your help.

Debjani

Chris,

Your SQL statement really looks very good. It has definitely improved some performance. I am still testing. Will inform you. Thanks again.

Hi Gail,

Here is the execution plan and the SQL scripts attached in the forum. Thanks for all your help

Thanks for being so patient. I will script out everything and post it to you.

Thanks,

Gail,

I might sound stupid, but I could not figure out how can I attach my database diagram which is a .pdf file along with this post.

And I can run the...

Gail,

I might sound stupid, but I could not figure out how can I attach my database diagram which is a .pdf file along with this post.

And I can run the...

Thank you very much for rearranging the SQL Statement.

The main idea is the database stores , how many users are getting which variation GRoupA, GroupB, GroupC, GroupD. And each group...

My Question is when Google Access the pge hits records through google Analytics. it does not take more than 5 secs. But mine is taking so longer . So there...

All the columns in my JOIN are indexed and also the ones in the where clause. The problem is 10 sql statements are running together. They are all helping to...

Ok sure , I will post the execution plan soon. Thanks.