Hi,

Thanks for the replies. Both approaches work (Scott's & Jonathan's). I've never used EXISTS before so must have a play with it. I also didn't know you could use a...

Hi Mark,

I just noticed a small error in your code so I'll correct it on the off chance somebody ever needs something like this again!

This line should be the other...

Hi, thanks for taking the time to reply. Yes, it works and is a lot more elegant (and probably more efficient!) than my way using a cursor. This was my...

Thanks, I'll have a play and report back on how it goes over the weekend.

Thanks Guys,

I think I can get it from that. My data isn't exact but I can get a good approximation from it (as weather data is anyway). I've made a...

Thanks: every day is a school day!

Hi,

Yes, that works thanks. I think I need to find out why though: I haven't used CROSS APPLY before.

That's exactly what I wanted to do. Very clever (I hadn't come across Grouping Sets before).

Thank you.

Hi,

Got it to work. Here is the other table:

CREATE TABLE [dbo].[tbl_Calculation](

[CalcID] [int] IDENTITY(1,1) NOT NULL,

[CalcKPI_ID] [int] NOT NULL,

[FK_KPI_ID] [int] NOT NULL,

[KPI_Operation] [varchar](50) NOT NULL

)

Then:

WITH Separated_Info(Period,...

That looks like exactly what I want to do. I'll give it a go and come back to you.

Thanks for the help.

Thanks Lynn

Don't ask me why but around a couple of hours a month was my gut feeling!

Any interest in doing this remotely?? (for a small fee of course:-))

SQLKnowItAll (4/11/2012)

---

That really depends on SO many things... I would say that database administration "could be" minimal if the application uses SQL Server correctly. You say you are proficient in...

Spot on guys.

Great help and thanks again!

Helps a lot. Thank you for going to the trouble of explaining it. And if you're up for one last question, teh last line of my previous solution containd the...