Home Forums SQL Server 2005 T-SQL (SS2K5) Update a table from select statement results RE: Update a table from select statement results

  • January 7, 2008 at 12:30 pm

    #765479

    How many rows are in MetaEvents?

    Also, there's no join between MetaEvents (the table you're updating) and calender (the table that the values are coming from)

    What determines which row of MetaEvents gets updated with which values from Calender? Or are you updating all rows of MetaEvents with the values from a single row of Calender?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass