Lowell (8/13/2009)

---

you'll want to compare that column against the current datetime, which you get from the built in GETDATE() function.

you also want to use the DATEDIFF function to return minutes():

ie:

SELECT...

GilaMonster (8/13/2009)

---

In my experience, statements like that mean they want someone...

looks like it should be:

Value;"\"C:\MyFileName.csv\""

You could use it for answering things like:

- give me the top 5 invoices for each client order by descending invoice amount

- every 10th invoice...

Are there any open transactions? Something holding some rows "open"? This should be trying to put some find of table lock down on the table, so something preventing...

RBarryYoung (8/12/2009)

---

The reviewers wouldn't necessarily have to be anonymous in the forum itself, as long as no one else could get into the forum. All you should need is...

I'd have to agree: unless you plan on radically changing the nature of the community, it would be difficult to introduce a panel of reviewers. I think the extra...

Did I miss the part which explains what doesn't work? Sorry if I'm being dense- I just don't get a good understanding of what is not happening. Syntax...

Lynn Pettis (8/10/2009)

---

Fixing the math should be the easy part. I didn't really look at what the calculation was doing, I just wanted to be sure I returned results...

doh... there I go picking up the wrong part of the quote. I was actually commenting on the "be afraid of the index scan" part of the conversation.

(I agree...

I'm just curious - you're calling that a "weighted average", but your calculation isn't anywhere near what is mathematically called a weighted average (or a running average, or really any...

That's a very different scenario than what Paul is talking about. You're looking at returning an indexed table variable, and he's talking about indexing a computed column (built from...

I know you know. I just hadn't...

UB (8/7/2009)

---

Matt,

I agree with the INSTEAD OF TRIGGERS, that's what I am gonna write my triggers in. Not all, but only some TRIGGER that do more than just auditing.

From what...

Why not store the value as a number, and do the casting...