Nobody can say that they were not warned now :).

Let me soften my tone a bit. You can select from the system tables.... assuming there's no usefull view that...

And, God Forbid, those 3 calculated columns could even be indexed. There's no reason to index all three but you could ;).

Is there anyway you can run that process at night and build the reporting table once a day?

You could even maintain it once-twice per hour with the new data if...

philcart (9/30/2007)

---

Congrats Steve, it does only seem a short time ago that we reached 400,000. With the new site I can see the growth only going upwards.

Remi, did you do...

Loner, I'm sick of seeing you hurt, and I'm sick of telling you what do to CHANGE YOUR LIFE for the better. This is the last time I tell...

I'll throw in 2 MS t-shirts from PASS 2007 if you send it to me instead ;).

Which one?? I think you had quite a few list in there.

Ok, for a moment there, I thaught you really were a super human DBA ;).

I see. I think it should be on by default. Then hidable when you don't want to see it. That way it's obvious that the feature exists...

Sorry Jeff, but I only audit full rows, not columns sot he 5:1 ratio doesn't apply.

2 what do you do about the rule that says that auditing data should be...

Please don't mention any names... don't want to hurt anyone's feelings.

:hehe:.

What's that?

Sorry if I offended anyone with my comment. It was not my intention.

Jeff as for the loop, I can appreciate a good mathematical solution. I wouldn't use it but I thaught it was neat.

So Jeff, how do you solve this version of the problem?

declare @i decimal(10,5)

Set @i = 1078.734

PRINT REPLACE(@i,'.','')

--What's needed? 107873400 or 1078734

Set @i = 0.034

PRINT REPLACE(@i,'.','')

--003400 OR 34?

Set @i = 0.0304

PRINT...