try DATEDIFF ( datepart , startdate , enddate )

SELECT DATEDIFF (d,GETDATE(), '31 dec 2013') for example gives the result of 342

(Not to OP)

The first parameter (for completeness for usage of...

Thanks for the question (and the point)

SQLRNNR (1/17/2013)

---

Right handed 2 prong metal...

The interview I had for my current job was 3 part, technical phone then face to face technical / personal along with on line testing and lastly panel.

At each...

A-Team

Brandie Tarvin (1/17/2013)

---

paul.knibbs (1/17/2013)

---

Bit uncertain about the description of Isolation. Surely the whole point of record locking is that it DOES prevent the other transaction until the first one is...

jasona.work (1/14/2013)

---

If an employer (or potential employer) wants to know about my private life that badly, hire a PI. At least then, digging into my private life is going...

Good question - thanks

Nice and straightforwards - thanks

Good question Wayne - thanks

Rescue

Thanks for the question - easy way to end the week

Thanks for the question Ron. Easy point today and without the need for coffee 🙂

Thanks for the question - and the easy point.

DugyC (12/24/2012)

---

Merde! If only I'd waited a bit longer... however Steve might be on hols with the family already.

....

Having determined 1,4 & 5 were correct in SQL2008, thought maybe this...