Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @i INT
- SET @i = 1
- while @i < 23
- BEGIN
- IF @i = 23
- break
- ELSE
- UPDATE Modules
- 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'
- WHERE ModuleID = @i
- SET @i = @i + 1
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement