I'm trying to write a trigger and a sproc to achieve the following ;
table A has fields
name,value,date,pb
joe,45.6,2013-11-10,null
joe,23.1,2013-11-9,null
joe,56,2013-10-01,null
joe,12,2013-10-02,null
I am now going to insert the two records
joe,65,2012-09-01...