Thanks DesNorton, that works great!

Much appreciated!!

Well now I just feel stupid. 🙂

Thanks for the help Matt.

Thanks for the response JonFox.

Each row represents the total number of vacation hours an employee is entitled to per year. For example, an...

Actually I was able to get it to work using this.

But there has got to be a more elegant way...

;with Total AS

(SELECT EV.EmployeeId, EV.TotalVacation FROM @EmployeeVacation EV

WHERE ev.id in (SELECT...

Thanks BrainDonor.

I did search before posting and was able to figure most of the issue out.

The part I am struggling with is determining how to ignore the year when the...

Thanks happycat, that worked great!

This leads me to another question now.

How can I update in a similar fashion:

UPDATE @ExampleTable SET

"SomeValue" = 100 - (SELECT SUM(CASE WHEN ET.SomeValue > 1 THEN...

Thanks Burninator and Chrissy321, that did the trick.

Damnit, I messed another detail up...

The value in the RemainingVacationDays column was wrong. It should be 82, not 254.

254 was the RemainingVacationDays value on Jan 1, 2011. This is higher...

Thanks for the help mister.magoo!!

The query works great for retrieving the remaining vacation to date.

However, the report allows the user to select a date range to query the remaining vacation.

For...

The front end allows a user to enter a vacation entry by start/end date and then the length...

Can anyone please help me out?

Thanks for your help Craig.

Here is the schema/data.

Yes, I have just hardcoded some values in there for simplicity sake.

I am only using the last entry in the vacations table becuase...

Thanks for the quick response Craig, it's greatly appreciated.

Yes you are correct the filtered hours should be 16, not 20 in this example.

I tried to simplify my post as much...

Sorry, I am doing a really poor job of explaining the functionality.

Let me take another stab at it.

A Manager creates a performance review for an employee, this is the master...

Hi toddasd,

Thanks for the response.

-"For the delete, make MasterReviewID on PeerReview reference MasterReview with a cascading delete."

Can you please provide an example?

-"But for the insert, I don't quite get it...what...