0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

create table #e (
    [year] int,
    [avg] int
);
insert into #e ([year], [avg])
values (
    2017,
    (
        select avg(score) from posts where year(creationdate) = 2017
    )
)
select * from #e

view current version

edited jan 21

created jan 21 corn.on.the.cob