Did you look at adding row groups to your datatable (right click on the far left of the row | Add Row). With this, you can then add rows...

Thanks Wayne.....that worked. I created another stored procedure that I could feed the description into and then populated my table from that.

the CTE method worked perfectly!

create table #cte( period varchar(4), actual decimal(16,2))

insert into #cte (period, actual)

select woper, sum(billdol)

from tc

inner join mat on mat = mmat

where client = @client

group by...

Derrick,

Thanks for the quick response; so something like this:

UPDATE #temp_client_spend SET actual = (SELECT sum(billdol) FROM tc

inner join mat on mat = mmat

WHERE client = @client and woper =...