Microsoft KB Archive/70829

PRSQL9103009: Cannot Assign a Local Variable a Computed Value ID Number: Q70829

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103009

SYMPTOMS Using the following syntax to assign a computed value to a local variable causes SQL Server to GP-fault:

  select @veryhigh=price from titles
  where price > 10 compute max(price)

CAUSE This syntax is incorrect.

RESOLUTION Use the following syntax to assign a computed value to a local variable:

  select @veryhigh = max(price) from titles where price >10