tried is nothing or = nothing??

Is the first column always for today... or the latest date with data?

Either waymy solution to find the max data from the dataset and compare that to the current group...

What's the difference between the 3 columns? So you basically only have 1 column group and 1 data column in there and you only want the first column...

Nothing attached!

I just don't get why you need columnposition = 1.

Can you show me a screenshot of what you want in excel?

Then why just changing that column's backgraound not enough? That will put the background for all of them as you want it.

GreyBeard (6/8/2011)

---

ROFL. No, don't shrink and, IMHO, don't reorganize unless you know the condition of the indexes. I have DBs that get 1M+ rows inserted / updated daily...

There were a lot of bugs in sql 2000 with dependencies but this is something that has been fixed in 2005 AFAIK.

If you need something better than right click on...

I'll assume you are talking about the log file(s).

In that case yes the reorg/rebuild is the culprit.

I personally only work the indexes that need work so that shot down the...

No way around that one.

You could possibly copy everything then use a script to drop what you don't need. "might" be faster but since you keep roughly 50% of...

How do you define first column?

The first column if each group of the matrix or really the 1st column period?

wta306 (6/8/2011)

---

Ninja's_RGR'us (6/7/2011)

---

Ask HR if it's possible to take a sabatical so that way your job is safe (tell them it's for a trip around the world if they ask...

srivathsani-296624 (6/8/2011)

---

You can also use sql profiler to find out which sp in your application is taking a lot of time.You can fine tine the performance of that Sp by...

Ask HR if it's possible to take a sabatical so that way your job is safe (tell them it's for a trip around the world if they ask too much...

Same folder? Running under the same credentials?