lungy (4/29/2009)

---

ja i have removed commented part AND still my front gives me the same error so it does not work

The original code is this one which gives me this...

GilaMonster (4/30/2009)

---

That's...

Here is an updated test suite.

create table #Order (

OrderId int,

DeliveryDate datetime,

Price money,

UnitId int,

...

HOWEVER!

What other status codes are possible, and is it possible that one order may have multiple statuses? I'm sure you only want to delete orders where all the items...

Flo,

No apologies needed. Your solution is the one I...

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...