Anyone lurking around this weekend?

Here is my initial try at using a cursor but I don't think it is going to work correctly.

I tried it selecting just 2 records into the cursor and it...

Because the SP does other things along with inserting a record into a master table, we can't rewrite it. I was initially going to insert only via code but was...

SELECT * FROM ptSchedule WHERE EncounterID IS NULL

would be the exact select query.

The exact SP call would be

exec rr_Insert_ptEncounter param1, param2, ...

No, I don't want a SP to do it, I already have an SP to insert the records.

Here it some psuedo-code:

for each record in table1 where columnx is null

...

Well one not so quick way would be to use a cursor on the table with the null values.

Thanks, Lynn, we've got it figured out now.

GilaMonster (10/30/2008)

---

Please define 'that doesn't seem to work'. Did it throw an error? If so, what error. Does it give incorrect results? If...

Yes, same structure.

Desired results:

INSERT INTO ptEncounterEncounterDetail_New ([EncounterID], [EncounterDetailID])...

Well, that doesn't seem to work either.

We need to build a new ptEncounterEncounterDetail from the EncounterID,

EncounterDetailID combinations where the Migration values are in the

old ptEncounterEncounterDetail (located on RabbitPM_brad)....

The code worked as planned.

Thanks.

1976 (10/29/2008)

---

Probably you may have another type of mismatch, which is a detail that is not listed in the master: then you need to modify the code to cover...

Ok, here's the final code:

CREATE PROCEDURE [dbo].[rr_Collect_EncounterReport](

@StartDtTm AS DATETIME)

AS

BEGIN

;WITH UniqueDescript(MRN, Description, StartDtTm, EndDtTm)

AS (SELECT DISTINCT MRN, Description, StartDtTm, EndDtTm

...

Good job, Seth

I fixed the problem with the CoPays by loading them in the CTEs with the

InsPlan stuff I also fixed it to bring over the SubscriberID so I...

Garadin (10/24/2008)

---

Thank you for posting all the definition, but if possible, could you put it all into a .txt file and attach that to your post (and delete it...