tm3 (12/29/2009)

---

Thanks for the feeback. I have taken your recommendations and attached the revised MS-Word document in a more standard format and added a section at the beginning for...

tacy.highland (12/29/2009)

---

See, the thing is, I'm writing the query in SQL2008 Management Studio, but I'm running it against a SQL2000 db. (perhaps this post shouldn't be in the SS2K8...

It will be dropped when your...

Paul Morris-1011726 (12/28/2009)

---

I removed the ISNULL and GETDATE() part of the code since it wasn't working the way I needed.

On the last row(what is returned)

2009-12-25 00:00:00.000 Some Status3 ...

Paul Morris-1011726 (12/28/2009)

---

What I need it to display is this:

pickdate status rownumStatusDays

2009-01-01 00:00:00.000New Case127

2009-01-28 00:00:00.000Released247

2009-03-16 00:00:00.000Treating392

2009-06-16 00:00:00.000Submitted430

2009-07-16...

Paul Morris-1011726 (12/28/2009)

---

Is the above what you were referring to as "readily consumable"?

I am going to need some help as I move along in learning and want to...

Ok, forgive me for seeming dense, but the greatest date of any in your sample data is '6/16/2009'. I don't see how you expect to return a value of...

If all you need to do is get rid of that NULL up there, see if this works...

SELECT

d.pickdate,

d.status,

d.rownum,

DATEDIFF(day, d.pickdate,...

Ivanna Noh (12/21/2009)

---

Those little fine tuning screws at the bridge are great - so easy to get a perfect tuning that way (assuming...

RBarryYoung (8/7/2008)

---

My oldest son is a Bass Guitarist. I met...

Paul Morris-1011726 (12/23/2009)

---

SELECT d.pickdate, d.status, d.rownum,

StatusDays =

CASE

WHEN d.rownum <> MAX(d.rownum) THEN DATEDIFF(day, d.pickdate, nextd.pickdate)

...

Paul Morris-1011726 (12/23/2009)

---

Thanks Greg for the feedback... Constructive criticism is always welcome. I am still new to this and I find the folks here very helpful. Let me see if...

Paul Morris-1011726 (12/23/2009)

---

hmmm ... I was reading Jeff Moden's article about Forum Etiquette: How to post data/code on a forum to get the best help and was wondering, am providing...

mail2payan, you should read Jeff Moden's article on the tally table, to understand the solution provided by arun.sas. It can be found here...http://www.sqlservercentral.com/articles/T-SQL/62867/. If you are not familiar...

Thanks Lynn. I'm going to have to take some time to figure this out, since I have never taken the time to figure out the new stuff like OVER().