Oh I didn't mean to sound that way either, just wanted to reiterate that anyone who helped me would not be doing my hw for me you know, and That...

Now while this is not homework, it is related to a SQL class I am taking. But this is me studying for the final exam not doing hw, though...

So the variable @SearchParam goes with the function?

Awesome! The Cte works!

*upDate* I got rid of the error message but it does not return any data??

Select course1.Ref_Number, course1.enrollment

From course As course1 JOIN Course As course2

ON course1.Ref_Number = course2.Ref_Number

Group by course1.Ref_Number, course1.Enrollment

Having...

It needs to be something like this, only problem is I get an error message stating "Msg 147, Level 15, State 1, Line 4

An aggregate may not appear in the...

so how would I go about changing it to a join

I think this gets er done!:-D

Select Ref_Number, Enrollment

FROM Course

WHERE Enrollment > (Select Avg(Enrollment) FROM Course)

Order By Enrollment DESC

Kind of like this?

Select Avg(Enrollment) As 'Enrollments'

(Select Ref_Number From course

Where course.enrollment > 'Enrollments')

From course

Group by course.enrollment

Not homework!! This is however me studying for my exam. Just tying to make sure I get them right and any help I may need, if your not interested keep...

Your help has been very much appreciated! I still have not gotten the answer but have and appt. so perhaps if you are on later I will update my code....

I did use it, however didn't really think about it like you said

The event that should cause it to rollback would be finding a duplicate entry right?

Oh this does exactly what I need it to do, however I must use a trigger here.

Ok so I switched it back to an after trigger and changed up my join but still cannot get it right, I know it has to be very close...