Okay, took a bit of thinking, and it is possible someone else may have a better idea but this works with your test data. You need to test further...

pdb DBA (4/30/2009)

---

Well here's my thinking (which is probably a bit twisted...) on it and why this didn't occur to me at first...

Sure, I know it *returns* the same value,...

the AVG returns the same type as entered. Since...

Nope, just would have written it with a CTE instead of a derived table.

John Deupree (4/30/2009)

---

Lynn Pettis (4/29/2009)

---

Are you looking for the date range a customer was active, or are you asking how many days a customer was active given a specified data...

Yes, Barry, glad to see you back! Take it easy for a few days.

trans54 (4/30/2009)

---

Sorry, maybe i did not explained correctly or did not provide enough information.

If any record in the orderid group has unit 89 then completly skip this orderid from purging...

I was spending a month with a friend in California the summer I graduated from high school and saw it the first time there. I saw several times again...

WayneS (4/29/2009)

---

John Deupree (4/29/2009)

---

What I need to know is how many days each consumer was active between 2 dates. Note that you can go from inactive back to active...

The quick and easy answer is that the full backup you restored was not the base full backup for that particular differential backup.

When I have to restore a database, usually...

If that isn't what you were asking, how about clarifying the question? You asked how...

greatheep (4/29/2009)

---

And that would make up the second most common of...

trans54 (4/29/2009)

---

Thank you so much, one more question:

How can i completly eliminate from delete orderid = 2765 if it has UnitID = 89 and UnitID = 4 in this case...

It could be that the SUM of the values is greater than the maximum value for an INT data type. Try casting it as a BIGINT:

select AVG(cast(ActivityID as bigint))...

karthikeyan (3/17/2009)

---

As i said earlier,

Politely saying, Since i visited our site more no of times(1370 visits from the joining date) and scored 1385 (comparing me with my related named...