Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @rowtemp table(TestRunID int, RunOrder int)
- SELECT TestRunID, ROW_NUMBER() OVER (ORDER BY TestRuns.TestTime ASC)
- AS 'RunOrder' INTO @rowtemp FROM TestRuns WHERE RunID = @runID
- DECLARE @rowtemp table(TestRunID int, RunOrder int)
- INSERT INTO @rowtemp
- SELECT TestRunID, ROW_NUMBER() OVER (ORDER BY TestRuns.TestTime ASC)
- AS 'RunOrder' FROM TestRuns WHERE RunID = @runID
- DECLARE @rowtemp table(TestRunID int, RunOrder int)
- INSERT INTO @rowtemp
- SELECT
- TestRunID,
- ROW_NUMBER() OVER (ORDER BY TestRuns.TestTime ASC) AS 'RunOrder'
- FROM
- TestRuns
- WHERE
- RunID = @runID
Add Comment
Please, Sign In to add comment