Hi All,

First of all thanks 4 ur suggestions. One thing i want to tell u all that i am not a person who is very passionate about cursors. All my...

Are u trying to update with this statement?: update Item set rate = (select rate from ....) where itemcode = @itemcode...

If so then what i think is the "select rate...

Sushila i think your answer - "your understanding of data retrieval is not correct" is simply avoiding the main problem. what i intended to know are some real facts that why...

The correct systax is:

Declare @var1 char(2)

Set @var1 = 'xy'

Select @var1 as Var1 from table_ab