Urgent --Multiple updates with one Query on the same column - either SP or Query
Posted on 2004-09-21
i have a column that is auto populated daily of type varchar. I would like a stored procedure that I could execute nightly that would go through the table and update it accordingly.
The table consists of values like "1 year", "2 years", ect. I want to strip the year(s) off of the table as well as look for some other things.
Is this possible to do in a simple query or stored procedure?