Merge si pe 2000. Tocmai am testat pe serverul din spatele RoSQL (un SQL Server 2000) urmatorul cod:

USE tempdb;
GO
CREATE TABLE T(I INT, COL_X INT, COL_Y INT);
GO
INSERT INTO T(I,COL_X,COL_Y) VALUES (1,2,1);
INSERT INTO T(I,COL_X,COL_Y) VALUES (2,3,2);
INSERT INTO T(I,COL_X,COL_Y) VALUES (3,4,1);
INSERT INTO T(I,COL_X,COL_Y) VALUES (4,5,2);
INSERT INTO T(I,COL_X,COL_Y) VALUES (5,6,1);
GO

SELECT SUM( T.Col_x * (CASE WHEN T.Col_Y = 1 THEN 1000 ELSE 1 END))
FROM T

-- Rezultat 12008

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro