Vladan,

Thanks for the reply, the way you have done it is very simple and for some one like myself who is learning its easy to understand, appreciate the help :)...

Hey guys,

Thanks for the posts, apologizes for not getting back sooner I just didn't have a chance to have a good look at the SQL. My original post showed the...

Thanks for the replies, this is all a little over my head but ill have a read of that article and see if i can come up with anything as...

Ray,

Thanks that pretty much does exactly what I hoped, thanks for the links as well could be very helpful 🙂

Thanks for the post, that SQL works very well just what I needed thanks. what I need to do is compare savings week on week. I'm not sure whats the...

Thanks for the reply, I just found out what is wrong, firstly if more than one record has the same profile_ID it seems to be adding the answers together...

GSquared,

thanks for the reply, that post that you maybe referring to http://www.sqlservercentral.com/Forums/Topic826285-1291-1.aspx was actually from me, I posted this problem a while back, however I only just began...

Well the only solution i can think of is having all separate columns for everything. When the chart runs it needs to grab data from a column, so lets say...

Chris,

Thanks, i know it does but i have one small problem, i also need the savings to be split into 4 columns, for example a policy savings column, building_savings, floor_savings,...

Thanks for the reply, this very nearly works thanks very much appreciate it, the problem with the reports i have to use unfortunately is that they wont process multiple results...

Thanks for the post appreciate it, unfortunately that doesn't solve my problem, Im stuck using MS chart Controls which don't seem to be able to process multiple sets. I tried...

Thanks for the advice and code, The code you provided works great for me, thanks for that, really appreciate the help 🙂

--===== Create Temp Table

CREATE TABLE #savingstemp

(

pc_profile_id int,

shutdown_Time datetime NULL,

startup_Time datetime NULL,

subpolicy_name varchar(50),

day_hour_rate float,

night_hour_rate float,

pc_kwh_rate float,

hours_off_day int,

...

Not necessarily which is one of my problems, for example if a computer shuts down at 01/12/2009...

Bru, appreciate the effort you made, thank you. This issue is quite tough to understand and I've been trying to figure it out for a while now. What I have...