| Subject | Re: [firebird-support] Query to update multiple records in same Table |
|---|---|
| Author | |
| Post date | 2015-05-20T07:20:15Z |
Thank you for the response Tomasz
The query works like a charm!
It is simpler & faster than the one I came up with & faster
Update analog a Set a.Name = (Select a1.name From analog a1 Where a.tag_no = a1.tag_no + 1238)
where a.tag_no >= 3671 and a.tag_no <= 3690
Regards
jack
The query works like a charm!
It is simpler & faster than the one I came up with & faster
Update analog a Set a.Name = (Select a1.name From analog a1 Where a.tag_no = a1.tag_no + 1238)
where a.tag_no >= 3671 and a.tag_no <= 3690
Regards
jack