Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009

    Question Unanswered: update query with tablenames from the result of a select query

    In my stored procedure , I have a select statement which retrieves some table names based on where condition.
    I have to update a particular column in all these tables using update query.
    my select query is

    select from sysobjects so,syscolumns sc where =
    and = 'productNum' and so.type = 'U'order by

    how can we give these dynamic tables in an update statement

    kind of urgent.. please help

  2. #2
    Join Date
    Dec 2007
    evidently you are using paradox tables in this process (but you don't specifically say so), but this is not a paradox question.. you'll get much better results if you post it on the appropriate SQL group here..
    Steven Green - Myrtle Beach, South Carolina USA

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    May 2009
    ya sorry it was a mistake...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts