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

    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 so.name from sysobjects so,syscolumns sc where sc.id = so.id
    and sc.name = 'productNum' and so.type = 'U'order by so.name

    how can we give these dynamic tables in an update statement

    kind of urgent.. please help

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    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

    http://www.OasisTradingPost.com

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

  3. #3
    Join Date
    May 2009
    Posts
    5
    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
  •