Click here to Skip to main content
12,449,919 members (48,746 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL
I want to insert new costcode values in to table only if the new value dose not exsist in costcode column already.
if it exsists so
the TranDate and amount will be updated for the exsisting cost code.

Simply:
if costCode exsist then update tranDate and amount else insert new row with new valuse for each column.

CostCode TranDate Amount
04 31/01/2013 12:00:00 AM 262033.83
07 31/01/2013 12:00:00 AM 31579.87
01 31/01/2013 12:00:00 AM 980834.24
09 31/01/2013 12:00:00 AM 197237.28

I need help urgently.

please someone help me here.
thanks
Posted 21-Feb-13 8:02am
Comments
joshrduncan2012 21-Feb-13 14:11pm
   
Saying it's urgent doesn't get guarantee you a quicker reply. What have you tried so far to accomplish this task?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

if(Exists(select 1 from tbl where costcode=yourcode))
begin

your update sql;
end

else

begin

insert sql

end
  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Query your table to see if your cost codes exists if it does then update the values that need to be updated, if it doesnt insert your new record.

SQL,

http://www.w3schools.com/sql/default.asp[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160826.1 | Last Updated 21 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100