Are you gonna run that statement everytime the rows are inserted/updated?? That's why I suggested the use of a computed column.

Oops, I thaugth sometimes the 4th was null... but anyone can be null so that's another problem altogether. Thanx for pointing it out.

I never set returnvalue to null... I don't see how that would help, if the Costx is null, then the condition will not be true so the status shouldn't change.

Make a function with 4 parameters. Then use this function in the formula for the column (becoming a calculated field).

The function would look something like this :

SET @ReturnValue...

And I know only one... which ain't the case here.

Why can't you add a computed column that will contain the lowest price? Also why isn't the price in its...

Stop having doubts... they don't know. The number of records limitation works CLIENT SIDE and has nothing to do with the server (excluding the part where less data is...

How can that option revert back to something else???

Sounds you have a problem with access or someone's erasing the file you're working with (assuming your modifications are saved in the...

Maybe she'll have some of that graved on your tomb .

Tools / Options / Advanced / Max default records at the top right of the form.

Next time you search, try the keyword concatenation. It should give you all the answers you need.

Where are you resetting that 10K limit?

I know you can do it form by form, and you can also set for the whole application.

Like this?

SET @MyVar = (Select name from Employees where EmpID = @EmpID)

Won't that break if you have more than one row updated at the same time??

Do you have set nocount on?

Select data, max(datecol) as datecol from dbo.YourTable group by data