Thanks for all the help!

I stumbled apon the exec() command prior to seeing your lasts couple posts PW,  and it does exactly what I need!  Much thanks!

I did it like...

Hey Liliana-

Thanks for suggestion.  I tried that, and T-SQL complains about syntax.  I think that 'GO' basicly executes all the script prior to it.  So because I have the Alter...

Hey Rodrigo-

I am referencing the same table, I changed my t-sql statement and received the same error:

Invalid column name 'TOTAL_VOTES'

any other ideas?

thanks!

Hey Sushila-

I tried your above method, but I get the same result...an error saying:

"Invalid column name 'TOTAL_VOTES'."

I don't understand what makes your method dynamic...can you explain?

thanks

thanks for the help PW!

How do you do Dynamic SQL for the update statement?  I've never done dynamic SQL...