I appreciate the help. I'm goingto try yours right now.  Its logic CMS uses and it threw me for a loop. It use to be different but now that they changed...

Thanks Sue,

I had a feeling I would have to do that. Was just hoping there was some ultra clever way to call it the executing Proc from inside the GetHistory...

Yeah, My bad on BEGIN/END its been a super long day. This did work but i'm sure someone has a better method. Also how do I grab the calling procs...

Hello All,

Sorry this took a bit but I started over with all of the indexing. It led to much better results I added PK's to each of the stage tables....

Hello guys,

I have tried several of the suggestions with mixed results. After finishing chapter 4 I think I am going to take Jeff's advice and start from scratch.

I'm not...

Thanks Jeff, i'll keep looking odd thing is I only have one <> 0 in the joins. Unfortunately I have not figured out away around it.

edit: I lied I have...

Update removed the local variable and used the straight param from the procedure input. Estimates got even better. Current first pass run time 25 minutes 45 million rows total. Prior...

Hi Grant,

So with the foreign key constraints I am have trouble testing that one out because I can't currently do "Cross-database foreign key references are not supported."

However next week...

Hi Grant,

One of your biggest fans here. Currently on Chapter 4 of your 2012 query performance tuning book. So much to digest here. No Foreign key constraints as of...

Thanks Alan !

One of these days i'll get good like that. Yes, that was much simplified. Looks like I was over thinking it.

😀

I think i figured it out. Ugly SQL but it seems to work.

Thanks

--Meeting, Subgroup, Session

CREATE TABLE #Table (MeetingID INT , Levels VARCHAR(20), ProviderName VARCHAR(20), PatientName VARCHAR(20), SubGroupName VARCHAR(20),SessionName VARCHAR(20))

INSERT...

Thanks Jeff,

After I posted I thought about it more and I guess the SAN made it kind of a moot point. Grant basically states at the beginning of the...

Well duh, i'll call that a senior moment even though I'm only 37 okay, going to give that a try as well.

Lynn you are always appreciated. You have helped me out so many times. You sir are very appreciated 😀