Nevermind, we've decided to do it differently in the rr_Collect_EncounterReport procedure.

Thanks for taking a look.

Ok, now that I have that part of it worked out. is there a way to do something like this?

CREATE FUNCTION rr_Get_BalanceByMRN

(

@MRN varchar(25),

@BalanceType int

)

RETURNS decimal

AS

BEGIN

RETURN exec rr_Collect_BalancesByPatient...

DOH!!!!

DECLARE @sql nvarchar(max)

.vs

DECLARE @sql varchar(max)

While that was a very good article, it seems a little over my head. Is there no way to find out why I'm getting the error in the code I...

I know about the posting etiquette thread but with this much data I felt it was too much trouble.

We have decided to do this using our business/data objects in VB.Net....

I'm not sure if I can post a complete set of test data.

There are 4076 records from ptSchedule and 9359 records from ptEncounter that would

have to be de-identified to post.

what do you mean here:

SELECT .......... UNION ALL

SELECT .......... UNION ALL

SELECT ...........

I don't know what to put as the ...........

Made this modification:

INSERT INTO #MySchedule

SELECT ScheduleID, MRN, ResourceID, StartDtTm

FROM ptSchedule

WHERE EncounterID IS NULL

AND MRN IS NOT NULL

...

IF RTRIM(@MRN2) <> RTRIM(@MRN1)

keep from updating the same MRN on the same DOS.

Each MRNs should have only one encounter record for each dateofservice.

Hmmm, never thought about that one.

Let me make...

Yes

John Rowan (11/3/2008)

---

Any...

I keep getting

[font="Courier New"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in...

Ok, here's a modification to the last script.

There is only one problem, however, it only updates approx 200 rows at a time.

It won't do all of them.

Any ideas?

CREATE TABLE #MySchedule...

Yes, I pointed it out in my last post, however, why would commented out code be relevant?

Did you get a chance to look at my last post to see if...

The issue isn't the cursor itself, it's the fact that you've got NULL = NULL at the end. NULL doesn't = NULL, NULL IS NULL. The update statement...

I did forget that, didn't I?

John Rowan (11/2/2008)

---

The problem I have...