Took me a couple to find the article from Jeff about this topic.

http://www.sqlservercentral.com/articles/T-SQL/74118/%5B/url%5D

derek.colley (5/23/2012)

---

Mike - I corrected the WITH to ;WITH and it ran beautifully - 28 seconds. Many thanks.

Lynn - trying yours now 🙂 The more practice I get...

OK if you really want some help you have to help me understand what you are trying to do. You want a new table with a single column in it?...

diva_di_dati (5/23/2012)

---

yes, I figured that when I omited the end as diag_1 from the end and still got the column of data.....where am I getting that last column from in...

komal145 (5/23/2012)

---

Entry_idevent_type_idEvent_valueevent_timelast_updated_userStatus

107141Initiated5/18/2012 16:01ADMIN

107145Customer Service5/18/2012 16:01ADMIN

107145Enrollment Technicia5/18/2012 16:07ADMIN

107145Customer Service5/18/2012 16:07ADMIN Pending

1071Imported5/12/2012 13:49ABD Pending

1075Enrollment Analyst5/12/2012 13:49ABD2 Pending

1071Routing5/12/2012 13:49ABD3 Pending

1073ENROLLMENT TECHNICIA5/12/2012 13:49ABD4 Pending

1081Routing5/18/2012 2:03ABDComplete

1085Enrollment Analyst5/18/2012 2:03ABD2Complete

1085Intake5/18/2012 2:03ABD3Complete

1083INDEXING5/18/2012 10:29ABD4Complete

1084Enrollment Analyst5/18/2012 10:53ABD5Complete

My...

diva_di_dati (5/23/2012)

---

If I run

select RECIP as recipno,

DIAGNOSIS_CODE as diag_1,

/*icd 9 codes must be 5 in...

Did you read the article that Paul posted? It explains DATEDIFF quite well. Here is again so you don't have to scroll around for it.

http://www.sqlteam.com/article/datediff-function-demystified

OP = Original Poster

--EDIT--

Now just stop Lynn...that is about the 10th post you did this today!!! 😛

quillis131 (5/23/2012)

---

Hello,

I was wondering and cannot think straight on this, So I came with an idea of getting ideas/views from different people..

HARD RULE : When a Primary Key is defined...

derekr 43208 (5/23/2012)

---

Yes. As I explained earlier, the first query has a correlated subquery in the EXISTS predicate. This query is run for each row in the outer...

So what do you want for output? Try creating a temp table and insert to hold what the desired output should be. I don't get it from your description.

So did my query answer what you needed? You said you had the first two figured out?

derekr 43208 (5/23/2012)

---

Thanks

I'm...

komal145 (5/23/2012)

---

From your query i am getting all the records whose current_step is not "enrollment_analyst and setting sattus = "pending"

But I need only those records which are in Current_step ="Enrollment_Analsyt"...

See if this wiki article will help in your understanding. Not a very in depth look but it may help you get what is going on.

http://en.wikipedia.org/wiki/Correlated_subquery