Result is not important, but an insight on what sqlserver tries to do internally when we execute the query. How does it arrive at 2,5,7 when the first row has...

result in @Table_D, should either be 2,5,NULL or 2,4,7 , but why is it 2,5,7

Yep , Prasad has given you a good solution

The best way is to follow the way explained in the link given by Frank Kails

Regards

Maths

Hey Lina,

declare @parm smallint

Select * from Table1 Where Isnull(COL,'<NULL>') = Isnull ( @parm ,'<NULL>')

Regards

Maths

One way to do it is to use cursors,

eg

Declare Cur_Var Cursor FOR

Select Id From tableA INNER JOIN tableB ON ... WHERE .... FOR Update

OPEN Cur_Var 

Fetch Next From Cur_Var Into .....@SelectedID

While @@Fetch_Status = 0

Begin

 UPDATE tableA...

UPDATE poz

SET tip='k'

FROM pos , juridic

pos.con = juridic .con

and juridic .dosar='p'