Post reply

Interesting site ...

  • July 28, 2004 at 8:18 am

    #163027

    http://www.wideman-one.com/gw/tech/accessjet/sqlposting.htm

    I know that this is for Access but was wondering if it would work for SQL Server.  I need to update my tables from a remote Oracle data warehouse and was wondering if this would run on SQL Server.  To answer my own question, it looks wrong and it doesnt work anyway ... but could it?

    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis

  • July 29, 2004 at 1:09 pm

    #516866

    The link you posted does not work.  If you can post a good one, I will look at it and see.

  • July 29, 2004 at 1:25 pm

    #516869

    hm ... it works for me ... but here is the SQL

     

    UPDATE Cumulative RIGHT JOIN Updates ON   Cumulative.Ix = Updates.Ix SET   Cumulative.Ix    = Updates.Ix,   Cumulative.Descr = Updates.Descr
    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis

  • July 29, 2004 at 2:55 pm

    #516882

    It works for me now also.

    It looks like it might work.  Try it and see (if you have a dev environment to play in)

  • July 29, 2004 at 2:56 pm

    #516883

    Incorrect syntax near the keyword 'RIGHT'.

    Kindest Regards,

    Seth Washeck

    If nothing in this world satisfies me, perhaps it is because I was made for another world.
    C. S. Lewis

  • July 30, 2004 at 6:51 am

    #516981

    Try RIGHT OUTER instead.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply