Hi All,

I have a table like the below table

EmpNo    Skills
1             C++
2             Java

Now after 1 week get an udated table which is like

EmpNo    Skills
1             Java
2             Unix
3             ASP
4             SQL Server

I want to update the table for "EmpNo" 1 & 2  and at the same time i
want to insert values for "EmpNo" 3 & 4 .How can this be done.

Thanks
Anshul

You need to do this in separate UPDATE and INSERT queries.

I have a table like the below table

EmpNo    Skills
1             C++
2             Java

Now after 1 week get an udated table which is like

EmpNo    Skills
1             Java
2             Unix
3             ASP
4             SQL Server

I want to update the table for "EmpNo" 1 & 2  and at the same time i
want to insert values for "EmpNo" 3 & 4 .How can this be done.

Thanks
Anshul

Hierarchically arranged attributes...mission impossible?
problem: select Max(date) which is less than actual Max(date) ?
Parameterize table name without constructing dynamic query?
Max date in a row
Constraints?