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?