Agreed, the NOLOCK was already on my radar.

Thanks guys.  I also thought the Bank filter may be unnecessary.  I tried removing it and got one more record than with it, I'll look into that.  It ran extremely...

Edit: Wrong Answer

• This reply was modified 3 years, 10 months ago by rothj.

Are your Statistics up to date?
I see it estimated 1.5 m rows but the actual was 4.2 m rows.
Then the sort spilled to TempDB.

I experienced this after my first migration.

I moved a database to new fast hardware but the speed seemed the same or worse.

I ran DBCC UPDATEUSAGE and SP_UPDATESTATS against the database.

It...

I had this issue in the past.

The culprit was a third party tool where log files that were not purged.

Redgate's SQL Backup didn't set a purge by default on the...

If you are changing the name of the server you need to dropserver/addserver.

--These Steps are needed after you rename the new server to the existing server name

sp_dropserver 'ServerName_New';

GO

sp_addserver 'ServerName_Existing', local;

GO

--restart...

Wow, that was easy!

Thanks, it gives me what I'm looking for! Appreciated!

Your example got me passed my error.

I'm good now.

THANKS!

Thanks for your response Laurie.

That is how I was initially attempting to get it done but I was struggling with the Cross Apply.

I appreciate your method.

Thank You Andy, that does give me the desired outcome.

I apologize but I left out one detail.

There are other Obsv Codes that begin with A_Med1 etc. (like Dosage,...

anthony.green (7/19/2012)

---

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to...

Call the vendor. Don't you have support from the vendor of the RX App?

I agree with the other posters, the ODBC config it is looking for isn't there.

Thank you Mark.