
April 18th, 2005, 05:37 AM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 30
Time spent in forums: 2 h 52 m 30 sec
Reputation Power: 5
|
|
|
pushing records into temp table
Dear friends,
I am using SQLServer 2000. I want some help. I have created 2 tables of same structure named mon_sal, and yrly_sal where i am storing only current month salary details in mon_sal and while processing for the next month salary i am pushing all previous months salary details to yrly_sal because i want to store salary details of that current month in mon_sal table. Each month i'll process this.
I want to write a query where i can push all the records from mon_sal to yrly_sal.
Please can anyone help me.
thaning you
shruthi
|