Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- while @i < 23
- BEGIN
- IF @i = 23
- break
- ELSE
- UPDATE Modules
- SET Presentation = 'Modules/Module' + @i + 'Module ' + @i + '-' + (SELECT ModuleName FROM Modules WHERE ModuleID = @i) + '.ppt'
- WHERE ModuleID = @i
- SET @i = @i + 1
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement