index_us (7/10/2010)

---

Hi, I am new to SQL databases and have been having trouble doing the following. I need to check that the the maximum value in one column of one table does not exceed the maximum value of one column in another table using a CHECK constraints. How do I do that if it does not allow me to use the MAX() function? The error message complains about the use of an aggregate function.

I can do it with a TRIGGER but is required to do it using a CHECK.

Help!!!

create function GetMaxFromTableB()
returns int
as
begin
   declare @ret int
   select @ret=max(colB) from TableB
   return @ret
end;

alter table TableA add constraint chkFunnyCheck check (colA<=dbo.GetMaxFromTableB());