Actually, some of the uses I've seen for Cache (http://www.intersystems.com/cache/) are quite functional. It's a pain to work with, at least what little I've done and from what I've...

Are you using Output Into, or just getting an on-screen output of the dataset?

If you're using Output Into, then select the value from the table you input into. If...

Digs (6/16/2009)

---

Well dont hold back.. how do you re build a table , and re load records into a table that has a identity key...

I guess you just turn identity...

One question is do they always change every month?

If not, then the first solution might not work, because you might be looking for "what was the name last month", and...

First, switch to Scope_Identity instead of @@Identity. It's a better option.

Second, move the assignment to right after the insert, instead of after the second insert. Or am I...

Since I can't look at the jobs, I don't have any suggestions beyond, "call Microsoft".

Not sure why there would be a difference.

Please try this, see if gets you what you want:

SELECT DISTINCT ctm1.ID, a.*,ctm1.Member

FROM

(SELECT DISTINCT ctm.CommitteeTermID,

MAX(CTM.ENDDATE) AS MaxYear

FROM mms.dbo.vwcommitteetermmembers ctm

WHERE YEAR(CTM.ENDDATE) =

CASE

WHEN MONTH(GETDATE()) IN (1,2,3,4,5,6) THEN YEAR(GETDATE())

ELSE YEAR(GETDATE())+1

END

AND

(ctm.rank...

You're welcome.

It is possible that data does not decay to uselessness in this situation. Even "old data" is sometimes critical to current data and operations.

But it's rare that you can't...

The composite column is just asking for trouble. There are reasons that you aren't supposed to store more than one value per row in a single column. Check...

GilaMonster (6/9/2009)

---

Ref please?

I can't see why. Index fragmentation is about the order of pages in the data file, shouldn't be...

Generally, the best way to publish them is to use Reporting Services. Is that what you mean, or am I misunderstanding you?

It shouldn't have a problem with it unless one of the steps has "On failure quit job and report failure" as one of the possibilities. Are you sure they...

You're welcome.

Take a look at "Exists" in Books Online or on MSDN. If you include statements like "or rank = 720 and not exists (subquery)" in your Where clause in...