Thanks, please consider this one.

I am newbee on this.

What I am trying to do is set @rec_num to 0 and then

Set @Nrec_num = @Nrec_num + 1

Set @SQLexec = 'Update dbo.tblname Set rec_num = '+Cast(@Nrec_num as varchar)+' from dbo.voters where part_no = '+@part_no

Exec(@SQLexec)

Can you please help me with this?