Tags: aggregate, appear, column, compute, containing, distinct, programming, representing, row, rows, sql, statement, supposed, table1, update, values, various

an aggregate may not appear in the set list of an update statement

On Programmer » SQL

704 words with 1 Comments; publish: Thu, 29 May 2008 01:32:00 GMT; (20078.13, « »)

Ok ... but how are you supposed to compute an aggregate of table1 rows with

a column containing various values for each row representing the distinct

set of those values in table2 ?

All Comments

Leave a comment...

  • 1 Comments
    • Your question is a bit vague.

      Please post your update statement, a SQL script to create the necessary

      tables, expected results, etc., and we may be able to help you.

      "John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message

      news:OrsJANSLGHA.3100.sql.todaysummary.com.tk2msftngp13.phx.gbl...

      > Ok ... but how are you supposed to compute an aggregate of table1 rows

      > with a column containing various values for each row representing the

      > distinct set of those values in table2 ?

      >

      #1; Thu, 29 May 2008 01:33:00 GMT