lo he solventado de la siguiente forma :
Código SQL
[-]
SELECT max(centro),
max(fecha),
SUM(visitas) AS rvisitas,
SUM(motnotot) AS rmotnotot,
SUM(motno01) AS rmotnotot01,
SUM(motno02) AS rmotnotot02,
SUM(motno03) AS rmotnotot03,
SUM(motno04) AS rmotnotot04,
SUM(motno05) AS rmotnotot05,
SUM(segllam) AS rsegllam,
SUM(vllamdec) AS rvllamdec,
SUM(impventas) AS rimpventas
FROM tb03P WHERE centro = 1004 and fecha between '2010-03-01' and '2010-03-20'
GROUP BY centro
me he complicado yo solo ya que creo que no es necesario utilizar tablas temporales ni nada.