Ok, I have 2 ptEncounter records with the same MRN and DateOfService. 9 ptDictation

records with the same MRN/DOS combination as the ptEncounter records, 2 ptSchedule

records with the same...

ALTER FUNCTION [dbo].[rr_GetDateFromDateTime](@DT datetime)

RETURNS datetime

AS

-- Returns...

I was able to cut the execution time by 2/3 by reformatting it like this:

select CASE

WHEN EXISTS (SELECT d.MRN FROM ptDictation d...

Luke L (10/10/2008)

---

Any chance you could pass along a bit of sample data and ddl as per http://www.sqlservercentral.com/articles/Best+Practices/61537/.

With just a quick look is this something that might go faster if...

Nevermind, found the answer here:

http://www.sqlservercentral.com/Forums/Topic581008-338-1.aspx

Vladan (9/30/2008)

---

I've noticed that column MRN is defined as varchar, while parameter @MRN is defined as nvarchar. In the procedure execution plan, you can see CONVERT IMPLICIT in the first...

The execution plans are located here:

Execution Plans

hold on, there seems to be a problem with my zip file.

Ok, it works now, I forgot to upload using binary mode.

I just can't understand why the execution plan is so different and the difference between calling as a query .vs calling as a SP is so great.

That didn't help, in fact, it made things worse as it took 12 seconds to load .vs 6, before I

added the local variables, on a particular MRN/Observation set, i.e.

exec...

To be honest, the data is for a medical practice management solution that has both a Windows and web client that use the same data.

It is horribly architected and, even...

We actually do, this is a script to convert a competitor's data.

This is how I actually ended up formatting it:

RTRIM(CAST(diagnosis1 AS CHAR(1))

...

Thanks ,Luke, I was unsure how to do that and we will just do it in the select like

you showed.

No, the cascading deletes, for some unknown reason, aren't working even though we have a Foreign key on the OrderID column.

Note: I just started here a little over a...

Yepper, that did it. Thanks a million.

I believe that may work for me. let me test it right quick.