Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Average calculation in a stored procedure...

Status
Not open for further replies.
Deam

Deam

Programmer
Oct 10, 2000
68
US
Hi,
I have to Calculate the average monthly salary and the Bonuses over the prior 3 months. Table1 has the Annual Salaries of Emps and is historical and Table2 has the Bonuses of the Emps and is NOT historical as an emp can have more that one bonus records.
What is the best way to do this ?
Any help will be greatly appreciated.

Thanks,
 
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
911
SashaBuilder3
SashaBuilder3
Bhashi
  • Locked
  • Question
Related to Average 1
Replies
1
Views
260
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
628
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
888
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
709
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top