SQLKnowItAll (5/28/2014)

---

Thanks for the thoughts. The list of connect items is really where I was focused, but I was curious of anything else that people have seen. We'll continue our...

https://www.youtube.com/watch?v=jLeOtRf6_1g&feature=kp

Pen

Another vote for the RedGate SQL Compare tools.

Nice license plate Jason S.

Have you tried the following?

Change the left join here

LEFT JOIN EPSTransactions t on r.OrthoID = t.PatientID

to this

RIGHT JOIN EPSTransactions t on r.OrthoID = t.PatientID

Perfect.

allergic

Have a look at these articles and see if they will help.

http://jasonbrimhall.info/2010/02/13/payperiod-ii/

Though the schemas are different, it seems to be the same general issue.

That remark seemed to come from left field.

As per the...

Here's an article from CSS on how to do that.

http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

Here's a quick and dirty script that seems to get what you want.

SET DATEFORMAT DMY

DECLARE @MarketShare TABLE (startdate DATE, rate INT)

INSERT INTO @MarketShare

...

Please post your query with sample data and we can assist.

&Cash

sql-lover (5/27/2014)

---

GilaMonster (5/27/2014)

---

Not actually true.

A good rule of thumb is picking table variables for small...

I too am curious why you are trying to eliminate the left joins.

I am also curious to see the full query and execution plan.