Stupid f"£$ing RDP connection has shut itself down and I've lost everything I did previously!!!!!! I'll now have to pretty much start again but that may not be a...

Of course I can :doze:

It makes repeated reference to creating an index on the TimeViolation table but that's read-only. The rest of it is so much hieroglyphics to me...

I've put a clustered index on the Violations table that uses the StartDate and one on the Sanctions table using the dateidentified. I'll be honest though and say what...

Thanks Grant, I've tried the TOP 1 approach and replaced the CTE's I was using with indexed temp tables but it's still not returned anything after half an hour. ...

I thought that as soon as I saw it 😀 Although...

Letter

djackson 22568 (12/12/2014)

BWFC (12/12/2014)

John Mitchell-245523 (12/12/2014)

I'm no lawyer, but as I understand it, TUPE protects you from any changes that...

You're welcome.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/ has a lot of useful date things if you need more.

Try using this

declare @ThisDate datetime;

set @ThisDate = getdate();

select dateadd(wk, datediff(wk, 0, @ThisDate), 0)

What's the actual error message?

We had problems importing files using ~ as a separator because one of the records had a ~ in the text itself. This knocked everything...

I think we're in scope automatically, from what we've gathered it doesn't matter whether there's a job a the other end, the incoming company has to take you on. ...

John Mitchell-245523 (12/12/2014)

I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made as...

Ed Wagner (12/12/2014)

Sky

I'm looking at this from a very different angle. This is my first tech job, to which I came 18 months ago on a long route through tourism, retail,...

Ed Wagner (12/12/2014)

Deep