Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 its very urgent for me

Author  Topic 

sql_lover
Starting Member

14 Posts

Posted - 2007-03-18 : 12:46:36
i wuld like to write a t-sql procedure (in sql 2000) which performs following operation

i need a procedure that matches current date with the effective date stored in the employee table and if match found then for each employee, updates basic salary of an employee to salary after increment.
pls help me regarding coz i m new to sql and sql procedures
thanx in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-18 : 12:48:58
Dupe http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80770


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

sql_lover
Starting Member

14 Posts

Posted - 2007-03-18 : 13:10:28
Actually m not able to see ur link(post) u gave
i dont know why
pls if possible pls repost here
btw thanx for the quick reply
Go to Top of Page
   

- Advertisement -