Well that still works.. depending on what you want to do with it.  The child proc will be able to access the temp table as if it had created it.

Nothing to add here.  Profiler is the only real option.

You can add the code to all the sps, but that still leave a lot of holes in the code (direct...

That's why I love to see and use scripts .

Maybe this would have avoided the truncatation of the post :

declare @var varchar(max)

select

@var =...

There's a lot more to that to do performance testing.

Are you using a sql server on a local pc (network can't be an issue)?

Are you emptying the procedure and memory...

It's hard to answer that one without seeing the test script you used.  Can you provide it to us?

Yup, I had an emergency and I couldn't provide the full answer.  That's why we are called a community after all.  Thanx Anders.

Also have you run any dbcc command to check the integrity of the database?

Here's a full script that creates a new users, adds him to the sa role and grant him access to the database.  Then it show how the sp_rename works.

At this...

How come this ain't in the format :

SaleManID, SaleAmount??

Precisely.

You need a table that maps the salesmen to a team (actually 2 tables).

If you don't have that you can do a cased group by but I would strongly advise...

Her name is loner.  Old hand is a nickname given based on the number of posts the person wrote.

Can't fully answer this one for a lack of time.

But you need to have a team table and a TeamSalesMan Table.

You then join the sale tables to TeamSalesMan to teams...

What I'm understanding is that you can afford to lose a full day's worth of data.  If this is the case then you can switch to simple recovery and that...