TheSQLGuru (5/24/2012)

---

Sean Lange (5/24/2012)

---

TheSQLGuru (5/24/2012)

---

Actually Grant I don't see even the slightest hint of a question from the OP - it is just a bunch of code. No request...

Does that work for you?

As the OP pointed out, this is a duplicate thread. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1305928-1633-1.aspx

There is probably a cleaner way to do this but this produces the correct results according to your sample data. I am kind of buried at work or I would...

Not much info in your post here. Pretty hard to offer suggestions about unknowns.

Take a look at the indexes stairway. It is a great series on understanding indexes. I suspect...

Oh, and as for banning - I say "no". You don't have to answer them, you can ignore anyone you wish. If people start getting banned for asking "basic questions",...

TheSQLGuru (5/24/2012)

---

Actually Grant I don't see even the slightest hint of a question from the OP - it is just a bunch of code. No request about what if...

SQLKnowItAll (5/24/2012)

---

Sean Lange (5/24/2012)

---

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things...

SQLKnowItAll (5/23/2012)

---

Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things to do with...

something like this help?

SELECT f.name AS ForeignKey, OBJECT_NAME(f.parent_object_id) AS TableName,

COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,

OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,

COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS...

SQL Kiwi (5/23/2012)

---

How do you...

LOL. I meant the info in your desired output. Obvious the inserts is fake stuff.

So it looks like Lynn and I posted the...

komal145 (5/23/2012)

---

I need a event_status table :

I want status for only those records which have sys_current_step(5) = "enrollmentanalyst"

and status will complete or pending.

I need to know the status of records...

I think something along these lines is what you are after?

select * from

(

select claim_stat, patient_nbr, status_note_code, biller_cd, form_id, patient_name, entry_date, process_date, tracking_id, claim_id,

ROW_NUMBER() over(partition by patient_nbr, claim_stat order by...

sqluser_8119 (5/23/2012)

---

I've attached the ddl for the table, the insert, and the desired results. I need to write a query that does this for duplicate Patient_nbr's:

- If...