update 1000 value in a column at once in MSSQL

[dips_1982]

I have table of three column like
Identifier  Description Value
    P1  x        20
    P2  y        20
    P3  x        20
    P4  y        20
    P5  x        20
    P6  y        20
    P7  x        20
    P8  y       20
    P9  x       20
          y     20
        x         20
        y       20
        x         20
        y        20
        x        20
        y        20
        x        20
   P1000    y                20


   I want to update value column with different values at once. I have created a stored procedure for that. But i am unable to furnish a small script for that. I have written thousands of UPDATA command to updat this list.

   Can any one help me out from this problem?

[adam_k]

It all depends on the values you want to assign and the criteria used. Can you please be more specific?

[pritaeas]

A simple UPDATE query could suffice. It all depends on what you want, for example:

UPDATE [table] SET [value] = 100 WHERE [value] = 20

[JorgeM]

Are you planning on updating various records with the same value or different values...please be more specific.