SHOW:
|
|
- or go back to the newest paste.
| 1 | declare @i int | |
| 2 | set @i = 1 | |
| 3 | while @i < 23 | |
| 4 | begin | |
| 5 | if @i = 23 | |
| 6 | break | |
| 7 | - | set Presentation = 'Modules/Module' + @i + 'Module ' + @i + '-' + (select ModuleName From Modules where ModuleID = @i) + '.ppt' |
| 7 | + | |
| 8 | update Modules | |
| 9 | set Presentation = 'Modules/Module' + cast(cast(@i as int) as varchar(2)) + '/Module' + cast(cast(@i as int) as varchar(2)) + '-' + (select ModuleName From Modules where ModuleID = @i) + '.ppt' | |
| 10 | where ModuleID = @i | |
| 11 | set @i = @i + 1 | |
| 12 | end | |
| 13 |
