Bulk Update (change) of SQL Database Column value

[raynkel]

I could use some help and I am completely clueless on this. I am hoping someone can(will)help.
I have a table with 9 fields:

UserID
Year
CountNo
ItemID
WarehouseID
ProgramID
Quantity
ModifiedDate
Location


The Field WarehouseID has a value of 32.
I need to change ALL of the records from 32 to 99.
If I knew anything about Stored Procedures I could figure it out, but have no idea where to start.
Any help would be appreciated.
Thanks
Raynkel

 

[Veep]

Type this into Query Analyzer and let it rip.
Update myTable SET WarehouseID = 99 Where WarehouseID = 32

 

[raynkel]

I used this and it worked like a dream. Thanks so much!

UPDATE dbo.tbl_AnnualInventoryCounts SET dbo.tbl_AnnualInventoryCounts.WareHouseId = '99'
WHERE dbo.tbl_AnnualInventoryCounts.WareHouseId = '32';