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