Scott,

I think that I was posting at the same time that you were editing your post. Let me work on what you've posted and see what I can come...

So, using this query:

select * from calendar

left join holidaytable

on calendar.[date] = holidaytable.hday

where hday is null

order by date

I'm able to get a list of just my business days.

Now I want to...

Ok, I'm close to finishing this up. I now have two new tables, the first one is dbo.calendar, which has a record for everyday for the next 50 years....

Lowell, thank you for the script.

sturner, would you be willing to share the stored procedure? We're a government agency, so I have a filling that our holidays will be...

Having a calendar table was my first thought, but how do you populate that table? Do you have to manually enter 8+ years?

Jordon

That worked perfectly, thank you both!

It's funny that you both came up with the same solution, at the same time!

Once again, thanks!

Jordon

One thing that I've found doing that way, is it only select's 1 record, so if all of that 1 record has 1's, then it doesn't show up on the...

You have been a great help! I've never seen a query written that way; however, it makes total sense when you look at it! Once again, thanks for...

Well, the first query that I was working on, which you helped me with, was to see which class has been schedule, but no work has started, meaning nothing is...

Thank you very much, once again! For my new query, I used what you gave me and did wrote this:

SELECT c.crs_id AS id,

...

I even tried this:

SELECT c.crs_id AS id,

c.crs_name,

c.crs_author,

c.sch_start,

c.sch_end

FROM SNP_crs c

INNER JOIN (SELECT ud.crs_id

FROM SNP_crsunits ud

INNER JOIN SNP_media md

ON md.crsunit_id = ud.crsunit_id

WHERE (md.intro = 1...

Alright, so now I'm going to add another layer of difficulty. This is for one last report that I have to create. This time, I want the class...

Even better! You're awesome!

Actually, I didn't need those fields. I changed the query to this:

...

That's it! You're a genus! Thank you so much for your help!!!