Microsoft KB Archive/70840

From BetaArchive Wiki

PRSQL9103020: Aliasing Column in Compute Clause GP-Faults SQL ID Number: Q70840

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL91030020

SYMPTOMS Using the following syntax within a stored procedure will GP-fault SQL Server.

  SELECT col1 FROM table COMPUTE aggregate=max(col1)

RESOLUTION Use the following syntax within a stored procedure:

  SELECT  col1 FROM table COMPUTE max(col1)