Viewing 15 posts - 12,241 through 12,255 (of 18,923 total)
Are you gonna run that statement everytime the rows are inserted/updated?? That's why I suggested the use of a computed column.
November 3, 2005 at 9:29 am
Oops, I thaugth sometimes the 4th was null... but anyone can be null so that's another problem altogether. Thanx for pointing it out.
November 2, 2005 at 4:21 pm
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.
November 2, 2005 at 4:05 pm
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...
November 2, 2005 at 3:23 pm
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...
November 2, 2005 at 2:48 pm
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...
November 2, 2005 at 1:09 pm
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...
November 2, 2005 at 1:02 pm
Maybe she'll have some of that graved on your tomb
.
November 2, 2005 at 1:01 pm
Tools / Options / Advanced / Max default records at the top right of the form.
November 2, 2005 at 12:37 pm
Next time you search, try the keyword concatenation. It should give you all the answers you need.
November 2, 2005 at 11:59 am
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.
November 2, 2005 at 11:54 am
Like this?
SET @MyVar = (Select name from Employees where EmpID = @EmpID)
November 2, 2005 at 11:52 am
Won't that break if you have more than one row updated at the same time??
November 1, 2005 at 11:04 pm
Do you have set nocount on?
November 1, 2005 at 10:32 pm
Select data, max(datecol) as datecol from dbo.YourTable group by data
October 31, 2005 at 12:42 am
Viewing 15 posts - 12,241 through 12,255 (of 18,923 total)