I have a stored procedure that among other things needs to get a total of hours worked. These hours are totaled by another stored procedure already. I would like to call the totaling stored procedure once for each user which required a loop sort of thing 
for each user name in a temporary table (already done)
total = result from execute totaling stored procedure 
Can you help with this
Thanks

It would be easier if you can change the stored procedure into a function. Once you do that, the total can be calculated easily with something like this
Select Sum(dbo.CalculateHours(UserName))
Fro  UserTable 
 
Save our world, its all we have! A must watch video Pale Blue Dot

 Please use the search feature of the forum before asking a question. 

I am so confused with this. I am currently using temporary tables (that is tables with an s because there are multiple of them) the tables are created with rows from the select statements with each row having a name and hours. I really need one table with a row for each user and their total hours. Can these tables be combined of better yet one table created with the data?

The function call
Select Sum(dbo.CalculateHours(UserName))
The UserName is where I need the many names that are in a table right now so it process all of them and generates many results

 
can i use 
Select Sum(dbo.CalculateHours(select UserID from #table Name))
 

I a not pursuing the multiple table solution but the one from above
EXEC @return_value = [dbo].[procName] 
@ID = 193
and the correct value is returned but how do I grab it?
 

Its done like this: 
 Select Sum(dbo.CalculateHours(UserID)) From #table
Save our world, its all we have! A must watch video Pale Blue Dot

 Please use the search feature of the forum before asking a question. 

 
The Stored Procedure uses a temp table.
Can a temporary table be used in a function?

 Yes, I believe we can use the function. Cant remember ever using it, but I think we can.
Save our world, its all we have! A must watch video Pale Blue Dot

 Please use the search feature of the forum before asking a question. 

I get the message 

Cannot access temporary tables from within a function.
when I verify the function with SELECT sum(myTime) as Hours 
into #tblHours
There must be another solution for this

you can Use Table Variables instead of temporary tables. They can be useful performancewise also
Give a man a fish and you feed him for a day.  Teach a man to fish and you feed him forever.