Answer
14 May 2013
license: CPOL
I prefer to use Common Table Expressions[^]:DECLARE @tdata TABLE (grp INT, val INT)DECLARE @dtmp TABLE (grp INT, val INT)INSERT INTO @tdata (grp, val)VALUES(301, 1)INSERT INTO @tdata (grp, val)VALUES(301, 2)INSERT INTO @tdata (grp, val)VALUES(301, 5)INSERT INTO @tdata (grp,...
General Programming » Uncategorised Quick Answers » General