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