Lempster (1/31/2014)

GilaMonster (1/31/2014)

Ryan George (1/31/2014)

Good idea. Maybe take your own advice? Would you tell someone that you've never met and that you asked for free advice from...

Dear Mr. Lange,

if you...

it is really interesting to hear. In a table, two prmary keys.

but this is a question which i got for an interview

i had options too. :doze:

as per the requirement, it...

Hi,

could you be more specific?

actually I didnt get your query clearly.

TOP 0 * INTO new_table FROM existed_table

You can use the MERGE statement.

MERGE your_table_target AS TGT

USING ( SELECT Code,'column1','column2','column3' FROM your_table_source) AS SRC

ON

TGT.Code=SRC.Code

WHEN MATCHED THEN

UPDATE

SET

TGT.updated_column= TGT.updated_column + " - Updated"

WHEN NOT MATCHED THEN

INSERT

(SRC.Code,'column1','column2','column3');

And,...

hi hoseam,

May I know the exact requirement of yours please?

this is just an update query. right?

If it is the requirement, then why you need to use a cursor.