|
Posted by Tim Roberts on 12/08/61 11:57
"version2" <corbett.jarrod@gmail.com> wrote:
>
>i am looking at resetting all the values in the column and giving the
>first value 10 htne 2 value 20 and so on
"First" has no meaning in SQL. You can just do a SELECT with ORDER BY to
get the records in the order you want, then build the UPDATE commands one
by one.
--
- Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.
Navigation:
[Reply to this message]
|