Craig Farrell (12/7/2010)

---

Ah, found the difference. I have a hard saved Tally table locally I swapped off to, instead of the on the fly one. However, I'm 1 based in...

Ah great thanks, thats just want I was looking for. Cuts the run time down from 24 sec to 8 sec. Thats a good start.

And what do you mean I...

mister.magoo: Thanks, I always wondered how the Cross Apply thinger worked. I'll look more into this.

Kingston Dhasian: Thanks, I'm aware that can be done and yes this is a simplified...

Right.. I knew that. Clearly I am trying to make this too complicated in my mind. Thanks

I got it, damn that took a long time. Thanks for the examples I was dead in the water trying this all yesterday

To get 5 years worth of quarters data

FiveYear...

Ok I got this thing working mostly. The problem is I simplified my example too much and now can't seem to get it to work. The table actaully holds a...

WayneS (10/4/2010)

---

SELECT EmployeeID,

DataYear,

YearlyWage,

FiveYearWage = (SELECT SUM(YearlyWage)

...

Ha, well I don't think I need a script as all of my FK are without indexes.

Thanks for all the information from everyone. This has been a very informative...

I would assume SQL is smart enough to use the FK and PK relations would it not? Or is it mainly because the PK for the employee ID not in...

Here are the table structures. Note I had called the JobGroups table the JobCode table in my example. It is really called the JobGroups table.

PersExpByQuarter

USE [WebRad]

GO

/****** Object: Table [WebRad].[PersExpByQuarter]...

1.) Don't know what BLOBs are, 2.) Don't know how to...

I'm thinking I may have to use a stored proceedure so I can pass in the parameters in the lowest part of the query, but I don't know that I...

Thanks for all the info guys, and ya, I may have just read too many bad things about dynamic SQL to ever trust it ha. As for the selecting all...

Wayne, thanks for that example, and yes I am now using that splitter function to create a table to join to. That works well, and I am happy with it,...

Thanks Wayne, I will look into that post. I don't want to go into dynamic SQL as I don't think it should really be used. I'm not a fan of...