insert into #tempmonthly(Duration,occupancy,occupancyGreater4,[adhoc request],[average request],[cut paste percentage],[Total Unique users]) values('FINAL STATISTICS',avg(@occupancy),avg(@occupancy4),sum(@adhocrequestcount),avg(ISNULL(@T_Emp/@TotalDays,0.00)),avg(@cutpaste),sum(isnull(@totalunique_users,0.00)))
INSERT INTO Table1 (Field1, Field2,... FieldN) SELECT 'FINAL STATISTICS', AVG(Field1), SUM(Field2), AVG(Field3), ... SUM(FieldN) FROM Table2 GROUP BY ...
INSERT INTO (Columns......) SELECT Query....
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)