SQL SUM on aggregate function

Question

Perhaps I'm trying to be too clever for my own good, and I could possibly use a scalar variable to solve this. I'm trying to add 1 to my output from the subquery;

INSERT INTO bookrevisiontbl (revisionnum, bookdate)
SELECT SUM(MAX(revisionnum) + 1), GETDATE() FROM bookrevisiontbl_tbl

However the following error occurs

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Is this query possible, and for it to maintain

eumiro · Accepted Answer · 2010-10-18 11:12:33Z

5

INSERT INTO bookrevisiontbl (revisionnum, bookdate)
SELECT MAX(revisionnum) + 1, GETDATE() FROM bookrevisiontbl_tbl

No need for sum as max will return single value

edited Oct 18, 2010 at 11:12

eumiro

214k36 gold badges307 silver badges264 bronze badges

answered Oct 18, 2010 at 11:10

Mark PM

2,90416 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

eumiro Over a year ago

@wonea, did you think about setting some sort of an auto_increment integer to revisionnum?

wonea Over a year ago

Agreed, I'm a little embrassed. ;-)

Collectives™ on Stack Overflow

SQL SUM on aggregate function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related