CREATE TABLE #temp(TYPEchar(1),INDINAMEINT,INDIVALUE INT);INSERT INTO #temp VALUES('A', 1001, 6);INSERT INTO #temp VALUES('A', 1001, 2);INSERT INTO #temp VALUES('A', 1002, 3);INSERT INTO #temp VALUES('A', 1003, 5);INSERT INTO #temp VALUES('B', 1001, 1);INSERT INTO #temp VALUES('B', 1002, 4);INSERT INTO #temp VALUES('B'...
|