Unfortunately the list only comes one way, in bulk. Since there are updates and adds in both the DNC and the customer table it was easier to just compare...

It is the National Do Not Call List designeed by a Federal Agency that we are forced to use...

The cost to have it in during the import is about an hour of extra load time I am told. I haven't seen this for myself. I will test...

I thought that was the case but originally the table had no index or PK. I added the PK and it did nothing to speed up my query. ...

Here is the return 0 part

case when

(DATEDIFF(minute,RequestDate+RequestTime,ResponseDate+ResponseTime) - @Max_ResponseTime) > 0 then

(DATEDIFF(minute,RequestDate+RequestTime,ResponseDate+ResponseTime) - @Max_ResponseTime) * @Fine_Per_Min

else 0 end as Fine

Yeah, I just tested the update and it only took 5 minutes 40 seconds.

I ran this test changing my update to a select

--old query with Steve's suggestion for the date parameter and Chris's suggestion to remove one of the nests.

begin

declare @dt datetime

select @dt...

the group by created the single line, the aggregate max() told it which value to show in the single line because each row would have either a grade or a...

most likely they will alll be unique but since you are grouping you must use an aggregate. I usually default to max but you could use min. If your...

I have done this with 360 columns and it works. You will not be able to use the dynamic solutions on the boeard because your select will run over...

Wow, you are editng your posts faster than I can ask my questions.

Does the event_id in td relate to the event id in the course list?

If no one...

How does the course list relate to the people list? Where are you getting their grade from? How do you know who took what course?

no, but we need to know what the columns are in the tables you are pulling data from to tell you how to solve the problem.

Can you post the create statements for your tables?

Chris, I think you are right that I could get rid of a nest by removing the extra fields. I will give it a test. I also think a...