Ed Wagner (1/5/2015)

---

CELKO (1/5/2015)

---

I've actually got a few recipes that call for equal weights of eggs and other ingredients. You weigh the eggs in the shells then match the...

It would be funny though, to change recipes to call for 25 grams of egg yolk fully encapsulated by 33.7 grams of egg white instead of just calling for "1...

Polish

I'm really not sure what you want to do here but it's best to include the columns you want by name rather than using SELECT * and trying to exclude...

ChrisM@Work (1/2/2015)

---

Thanks.

Query 1 (insert into #temp_violation etc.) has an odd filter:

and

(

cast(fh.startdate as date)<= cast(tv.startdate as date)

and

cast(fh.startdate as time)<= cast(tv.startdate as time)

)

This will capture datetimes from fh where they...

ChrisM@Work (12/31/2014)

---

Can you post the execution plan? Done

Have you considered using EXISTS No I hadn't, see my earlier comment about being a noob 🙂 The fact it ran at all...

I've finally got back to this after the Christmas break and a brief sojourn in proper work.

Thanks for your advice gents. I learned something very useful about execution...

Elbow

Wood

David Burrows (12/18/2014)

---

Oh! Joy 🙂

Sounds like one of...

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...