Viewing 13 posts - 1 through 13 (of 13 total)
I knew about Truncate, but you have provided useful information about how it differs from DELETE FROM. Thanks
November 22, 2007 at 2:39 am
First I should say that you were correct when you suggested that ints in the function should first be converted to reals - I discovered (in fact I knew this but...
August 1, 2005 at 11:14 am
>> Is it possible the result happens to have only two significant digits to the right of the decimal because of the values in the columns. In Query Analyzer,...
August 1, 2005 at 8:27 am
Ignore the stupid question in my last post. If the sum is divided by 4 the decimal part could only be .25, .5, or .75, couldn't it?
So, in fact the formula...
August 1, 2005 at 7:14 am
Further to last message. I was in error re Col3 computation.
There are FIVE columns; MeanValue = Avg(Col1+Col2+Col3+Col4). Col5 doesn't figure in this, but......
If Col4 is null, derive Col4 value from...
August 1, 2005 at 6:24 am
Thanks for all replies.
>> better yet - could you explain in detail what colA should be based on certain values in columns b, c & d ?! I think you...
August 1, 2005 at 3:10 am
Sam, Robert, Dhaval, Leifah
Thanks to all of you for your help (and particular thanks to Sam for his patience and persistence). I managed to get it working in the end.
November 30, 2004 at 10:32 am
I've now been through the various suggestions: set zero as the default value for all bit fields, deleted existing links, relinked the tables etc... all to no avail, I'm afraid...
November 26, 2004 at 11:04 am
To all who have replied so far - thanks. I'm a bit busy with other projects at the moment, but as soon as I've tried your solutions to this teaser...
November 24, 2004 at 8:43 am
Thanks for the reply. I tried your solution but I'm still getting the same problem as before (Write Conflict - The record has been changed by another user since you...
November 23, 2004 at 2:47 am
Avi and Antares686
Just heard from my colleague at the remote server that it's all working fine now. Putting the server alias in there did the trick. Thanks a lot for...
September 24, 2004 at 8:12 am
Forgive my ignorance/inexperience here, but I'm not quite sure I understand.May I ask for clarification?
Having added the server alias of the remote server in the Client Network Utility on...
September 24, 2004 at 3:24 am
Thanks for the reply, Avi.
I don't have access to the remote server so I'm having to wait for someone else to tryh what you have suggested. I'll let you know...
September 23, 2004 at 4:37 am