Todd, if you've got data like this:

INSERT INTO MemberLabResult

(MemberID, LabDate, LabID, Labvalue)

SELECT '1','10/17/2008','1','3.2' UNION ALL

SELECT '1','12/17/2008','1','2.0' UNION ALL

what should be the average for last 2 months?

1.0 or 2.6?

Steve Jones - Editor (4/13/2009)

---

I'd go with ALZDBA's solution, but you should define what 1 year and a half means to you.

If it's early Sept and you go back a...

If it's possible try to order the data before it's being inserted, in SELECT part.

Shuaib (4/10/2009)

---

Hi

I need to append the value for an existing text data type column value in sql 2000. Can someone give the scripts? I have to update for...

Steve, anything about THE MATTER?

If you did not notice it's kinda professional forum.

It's not so hard to set up a test...

Only one of them. 🙂

You answered your own question.

If you need details...

Remove all indexes but clustered.

Recreate dropped indexes after populating the table.

But actually moving of such a chunk of data away for processing is not such a brilliant idea.

There must be...

RubyRed (4/9/2009)

---

I have a table with AGENT_NAME that contains last and first name separated by a space. I need to separate the last and first name out into two...

So, it's a lotto, or just like lotto, right?

If so, and i "performance is very important" you need to take care about data normalization.

-- Normalized data storage for registered tickets

CREATE...

So, it's a lotto, or just like lotto, right?

If so, and i "performance is very important" you need to take care about data normalization.

CREATE TABLE Ticket (

What about repeating values - is it possible in table and/or variables?

Does the order matter?

Can values be repeated in columns/variables?

O it's like in a lotto: variables are the winning numbers and table contains all registered tickets?

Which values?

Some values given from outside...