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

Okay, I started a formal poll.

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 range?

Now for something totally the same...

How many people, besides...

Sibbs (4/29/2009)

---

Hello,

I have been implementing some session source tracking on our SQL servers, and am unclear on any difference between the APP_NAME() and PROGRAM_NAME() functions.

Most of the code examples I...

But how many of you can actually visualize Darth Vader and Yoda working together??? :w00t:

Mh (4/29/2009)

---

GSquared (4/28/2009)

---

It's an undocumented table that SQL Server uses for it's own stuff. Basically, don't even try to change anything in it, but it can come in handy...

I hope the following code will help you:

/*

ORDERID DeliveryDate Price UnitId Status

2765 2009-02-13 00:00:00.000 49.95 4 Completed

2765 2009-02-13 00:00:00.000 9.95 89 Completed

2765 2009-02-14 00:00:00.000 49.95 89 Completed

2766 2009-02-15 00:00:00.000 19.95...

Roy Ernest (4/29/2009)

---

I am reaching that magic figure of 1000. But that does not mean I know anything. But I try to learn from reading the solutions to different problems...

And yet, I managed to redeem myself in that very same thread! (The silence in the desert is deafening!) 😉

Scott Roberts (4/29/2009)

---

Jeff Moden (4/29/2009)

---

Scott Roberts (4/29/2009)

---

Sorry about the confusion over mis-matched data sizes for RawData. The RawData column used to be VARCHAR(300) but we encountered a new format that...