i'm try understand the reason for that error massege:
'Selected non-aggregate values must be part of the associated group'
CREATE VOLATILE MULTISET TABLE SWT_QuickConversion105 as(select 0.5 as v_A_Size,0.0 as v_ControlPer) WITH DATAON COMMIT PRESERVE ROWS;
CREATE VOLATILE MULTISET TABLE tt_MaxSize AS (select tt_RandNum.FinishBonus,MAX(tt_RandNum.randNum) MaxRand,round((MAX(tt_RandNum.randNum)*v_A_Size),0) AS EndRange_GroupA,round(MAX(tt_RandNum.randNum) -(MAX(tt_RandNum.randNum)*v_ControlPer),0) AS EndRange_GroupB
from tt_RandNum cross join SWT_QuickConversion105group by tt_RandNum.FinishBonus) WITH DATAON COMMIT PRESERVE ROWS;
this is part os store prosedure code, whene i create the temp table the compiler give me error msg:
'Selected non-aggregate values must be part of the associated group' i put instsd the value:v_ControlPer,v_A_Size numbers: 0.0,0.5, and i success create the SP.
But when i try call that SP i got the same error.
someone know why?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.