Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Difference between Truncate and Delete

    I knew about Truncate, but you have provided useful information about how it differs from DELETE FROM. Thanks

  • RE: Column formula

    CJohnson

    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...

  • RE: Column formula

    Hi CJohnson

    >>  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,...

  • RE: Column formula

    Duh!

    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...

  • RE: Column formula

    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...

  • RE: Column formula

    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...

  • RE: MSAccess to SQLServer 2000 via ODBC

    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.

    The...

  • RE: MSAccess to SQLServer 2000 via ODBC

    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...

  • RE: MSAccess to SQLServer 2000 via ODBC

    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...

  • RE: MSAccess to SQLServer 2000 via ODBC

    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...

  • RE: ADO Connection to SQL 2000 problems

    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...

  • RE: ADO Connection to SQL 2000 problems

    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...

  • RE: ADO Connection to SQL 2000 problems

    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...

Viewing 13 posts - 1 through 13 (of 13 total)