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 |