T_Dot_Geek

This solution also works as well!

Thanks again for looking into this for me!.

Cheeeeers 😎

micky,

This works perfect!

Thankyou for taking the time to help me out 😀

T_Dot_Geek (10/31/2012)

---

I am new here. I need your advise.

In my previous reply I designed queryin my SQL Server and copy paste here. It is looking flat text in my reply....

Thanks for the reply....

Hmmm not quite what I was after.

This places the Region Code under the Original, RiverLaKes_WWFL and RiverLakesSev123_WWFL and gives the WholeACNet in one column.

Ideally Region_Code would be...

Sample Data

CREATE TABLE Regions_Pivot_Test

(

Fail varchar(3),

...

The Regions will remain static!

Just going to work on uploading the sample data...

I will get on to that!

If you check out some of my other posts I normally asks for hints and tips and an explanation of whats going on in the...

The current query to produce those results is in 3 steps that takes an individual location, groups it into an account and then a region. it scores each location and...

Will take a look!

Is that the most efficient way to go about it or is it worth revising the query?!

Thanks Again!

Option Number 1, it made more sense in my head!

Thats fantastic,

I have already used this method on 2 other queries and it works a treat, not to mention nice and fast!

I cant thankyou enough for your help today.

Have a...

Excellent....it works!

Now I don't just want to take the code and go on my way. When I first attempted to do this I used a 'Where' clause to find out...

Okay I hope I followed the rules on this!

Create Table Derived_Help

(

ACCGRPNUM varchar(20),

ACCGRPNAME varchar(40),

Region ...

That didnt do it...damn it!

The error I am guessing is here

SUM (a.Pass/(COUNT (ACCGRPNUM))) as RATE

using the ACCGRPNUM to get the total number of locations by Region kicks out...

All Done,

Stupid of me to sum and group again as it had already been done, results now set to decimals and I have got the data set I need.

What a...