Lynn Pettis (8/22/2009)

---

You are right, to a point. But...

I can't tell for sure, but your Where clause looks like you're trying to just get the most recent run of the job. Is that correct?

Take a look at OpenRowset, OpenDatasource, and OpenQuery in Books Online. There are ways to use those to query a proc result-set as if it were a table.

If you really want to get rid of them all at once, run this:

select 'drop table ' + name + ';'

from sys.tables

where name like 'tmp%';

That'll give you a list of...

Some data is better lost than left unsecured. Most isn't. There's always a balancing act between security and usability.

On the school locker thing, I actually got to the...

I think this would be a good option for high-security systems. I don't think it will fly in most small businesses.

It can be done with a temp table. That's how I generally handle...

It also just got you onto a list I keep of people I won't ever help again.

There are three people...

Yep.

Actually, in taking another look at this, a variable is completely the wrong solution. Would have seen that earlier if I were able to test this, but I don't...

That's definitely the right place to start.

I'd rebuild over 20, and the reorg the rest that're over 10.

Gianluca Sartori (8/21/2009)

---

RBarryYoung (8/21/2009)

---

Gianluca Sartori (8/21/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if...

You can use the shrink file option to empty the data from the file into another file. Then you'll be able to get rid of it.

I guess I don't understand your request. You say you need to replace this:

(VV.Fund_Valuation_Date = (SELECT MAX (Fund_Valuation_Date)

FROM dbo.Fund_Valuation VVV

WHERE VVV.Fund_Valuation_Date < '2006-09-01'

AND VVV.Fund_Number = V.Fund_Number

AND VVV.Class_Type_Abbr_Name = V.Class_Type_Abbr_Name

AND...

Load it into a staging table, and build a proc that handles it from there.