|
lionofdezert
Aged Yak Warrior
Pakistan
864 Posts |
 Posted - 07/12/2012 : 06:54:02
|
CREATE TABLE #UpdateAsPrevious (PriCol INT, ColA INT, ColB INT)
INSERT INTO #UpdateAsPrevious
SELECT 1, 1, 2 UNION ALL
SELECT 2, 1, NULL UNION ALL
SELECT 3, 1, 5 UNION ALL
SELECT 4, 1, NULL UNION ALL
SELECT 5, 2, 1 UNION ALL
SELECT 6, 2, NULL UNION ALL
SELECT 7, 2, 3
SELECT PriCol,ColA,
ISNULL(ColB,( SELECT TOP ( 1 )
ColB
FROM #UpdateAsPrevious
WHERE PriCol < OuterTable.PriCol
AND ColB IS NOT NULL
ORDER BY PriCol DESC
)) AS ColB
FROM #UpdateAsPrevious OuterTable
ORDER BY PriCol
DROP TABLE #UpdateAsPrevious
--------------------------
http://connectsql.blogspot.com/ |
Edited by - lionofdezert on 07/12/2012 07:07:34 |
 |
|
Update Rows based on previous row
