If I understand your question correctly, see if something like this will work for you.

CREATE TABLE T2000(ID Int,Dated DATETIME,Amount DECIMAL(10,2))

INSERT INTO T2000

SELECT 1, '2012-02-03 00:00:00.000', 100.00 UNION ALL

SELECT 1, '2012-02-03 00:00:00.000', 25.00 UNION ALL

SELECT 1, '2012-02-03 00:00:00.000', 125.00 UNION ALL

SELECT 2, '2012-02-04 00:00:00.000', 50.00 UNION ALL

SELECT 2, '2012-02-04 00:00:00.000', 15.00 UNION ALL

SELECT 3, '2012-02-07 00:00:00.000 ',190.00 UNION ALL

SELECT 3, '2012-02-07 00:00:00.000', 210.00 UNION ALL

SELECT 3, '2012-02-07 00:00:00.000', 60.00 UNION ALL

SELECT 3, '2012-02-07 00:00:00.000', 40.00

CREATE TABLE #X(ID Int,Dated DATETIME,Amount DECIMAL(10,2))

INSERT INTO #X

SELECT ID,Dated,SUM(Amount) FROM T2000 GROUP BY ID,Dated ORDER BY ID

SELECT ID,Dated,Amount FROM #X

CREATE TABLE Second(ID INT,Whoops VARCHAR(20))

--My mistake ID should have been analysis_code1

INSERT INTO Second

SELECT 1,'YUP' UNION ALL

SELECT 2,'Maybe' UNION ALL

SELECT 3,'Yes' UNION ALL

SELECT 4,'Nope'

SELECT c.ID,c.Dated,c.Amount,s.Whoops

FROM #X c

JOIN Second s ON

c.ID = s.ID

-- Result:

12012-02-03 00:00:00.000250.00YUP

22012-02-04 00:00:00.00065.00Maybe

32012-02-07 00:00:00.000500.00Yes