SQL Server 2005: Insert a row in a table and update the same row

Posted by vikas on Stack Overflow See other posts from Stack Overflow or by vikas
Published on 2011-01-07T00:20:34Z Indexed on 2011/01/07 7:53 UTC
Read the original article Hit count: 201

Filed under:

sql-server-2005

|

triggers

eg:table

pkey --guid
annualpay
datefrom
dateto--if null means current record
percentannualincrease

percent annual increase will be calculated only if there is a difference in newly inserted and previously existing last differing value.

percentannualincrease =
   ([newannualpay-just previous pay(if different from current)]/newannualpay)*100

eg

newid(),5000,today,null,0--very first row
newid(),5000,today+1,null(*),0
newid,5500,today+2,null(*),?????????????--> need to be calculated before insert

*--insert will close the previous record by updating dateto=null to todays date

How can I do this stuff in a trigger???

© Stack Overflow or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about triggers

Instead of Triggers - Can they coexist with regular Triggers

as seen on Stack Overflow - Search for 'Stack Overflow'
Can Instead Of triggers co-exist with regular triggers? If so, are there any potential issues we should be aware of? >>> More
Ask Tom - "The Trouble with Triggers"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Protect sensitive information and achieve regulatory compliance with Oracle Database. >>> More
"On Redefinition, Nature, and Triggers"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Our technologist redefines tables, compares keys, and warns about DDL in triggers. >>> More
JDBC Triggers

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Received a question from a customer last week, they were using the new rollup patch on top of 10.1.3.4.1. What are these boxes for? Don't you know? Surely? Well, they are for ... that new functionality, you know it's in the user docs, that thingmabobby doodah. OK, I dont know either… >>> More
Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle? >>> More