Hi, yeah I just tried that and it works if I include the specific AND p.dbPatCnt = 9678 but the query just runs for ever without it.

I've tried this - just on one dbpatcnt = 9678 and it brings back 12 rows all with different LastVisitDate and LastVisitDesc. What I require is for the sql to...

thanks.

adding just that Cross Apply code to the bottom of my existing where statement brings back the same lastvistdate and lastvisitdesc for all rows.

I think I need to be able...

Thanks for a lot of useful info guys.

In the end I deleted all data everywhere that had clientref = 'PRE' then re sync'd and it now works ok.

Hi twin.devil,

they sound like good suggestions but..

check the execution plan - how?

recompile option with timeout query - how?

statistics properly updated - how?

check if index is fragmented - how? - I'm...

just to add to this post, I'm using Azure sql server.

Not sure how to view the server logs on azure sql server compared to local servers through SSMS.

thanks,

thanks. actually ended up using a much simpler solution in the end where I didn't need to use DATEPART.

is there a sql command that displays special chars as well, so if a do a select it will display the whole field not just visible text and white spaces...

trimming on both sides of the join hasn't made any difference

Hi thanks for the reply,

so your suggesting using the trims on both in the where clause/join? do trims work in the where/join?

I'm not able to amend the data that's...

I forgot to mention in my question about whether to install 32 or 64 bit 2008 r2 that I was talking about the EXPRESS edition (with adv services).

So it turns...

It turns out that for a ss 2005 upgrade to ss 2008 r2 on a 64 bit for EXPRESS editions you need to use the ss 2008 r2 32 bit...

Just an update to this. When I ran the upgrade it DIDN'T ask me to select an instance (ie the 2005 instance)

Seems like 64 bit is the way to go

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2c463d34-599c-4da4-a1ca-1b5425af1aae/upgrade-using-32-or-64-version-of-ss-2008-r2?forum=sqlsetupandupgrade

Ah, simply google sorted that out - SELECT @@VERSION.