Thanks for everyones help.

The first SQL only pulls the dependants, the second was an example I thought would work. Any ideas how I can do this? I created a union statement that kinda...

Thanks Jason!!   I appreciate your advice also!

Thanks!  That worked. I'll need to read up on my joins to figure exactly what is going on here. It appears you have done "filtering" in the join statement on...

Thanks Everyone!!!  I've got it working..

I guess this would be the best I can do..

Cumulative Hotfix for SQL Server 2000 Service Pack 4 - Build 2187 for x86 and x64 Based Systems.

The only thing different between the two records would be the check number and amount. Everything is exactly the same, I can't even use date/time because they are the same....

I do all need all the employees at one time, just thier most recent record in the table.

select top 1 *

from phbasic

where pay_period_end = '11/25/2006'

only returned one record (total) as...

I always want the last record in the table for the date I specify, it will have the most current data.

Thanks for the help everyone!!!!!!!!!!!!!!

  Thanks everyone for your help!!!  Greatly appreciated

jim

Ram,

First off, thanks for the help. The only problem I still have in your example is when the code meets the "IN" criteria, I want it to sum up all...

Thank You!

How do I reference a static variable in a where statement in T-SQL. No user input, variable always = 12

then how would my datepart(dd,hire_date) command by set up?

thanks

Damn, you guys are quick. By the time I figured it out, I had 2 great replies. Thanks!!!

see anything wrong with this? just curious with the difference would be and why you chose dataadd over datediff

where datediff(d,hire_date,GETDATE()) <= 90

thanks!!!