Yeah, huh?  Still can't get used to that...

Thanks guys.

"20 minutes through Toad" doesn't use linked servers... it uses direct connections.  Are you trying to join Oracle tables though the linked servers?  That's probably not going to work so...

What would be more interest is to find out why you're storing this data in a table to begin with... distance calculations are not that difficult even when based on Lat/Lon.

Heh!  Yeah, I'd like to see that, as well

You didn't say how big TempDB had gotten... how big is it?

So... no feedback on my questions, am?

Thanks for the feedback, Gova.

Michael's suggestion of using his very fast date generator function would do nicely.

Strange to have a DBA that won't allow adding helper tables to a DB...

Thanks, Edogg... appreciate the effort...

... but why in the hell won't the OP tell me   All take, no give... I've asked Tracey twice, now....

OK... Thanks for the feedback and understood...

I see a couple of folks have already given you a solution but I am curious about the source of data (always looking for...

I hate it when fish smells like rotten eggs

No problem, Michael.  But I am curious what the OP actually wants... it looks like he's trying to display the tree for a current drill down into a set of...

Um... what do you mean by "manually eiditing the table"? 

Dollars to donuts the views are aggragate views that either return to many columns or might even have views of views or UDF's.

Also, any of these tables have a primary...

Don't change anything that's owned by the system... period.

Make a copy of sp_SpaceUsed under a different name and then make all the changes you want.