set dateformat ymd

declare @ToDate datetime

declare @FromDate datetime

set @FromDate = '2014-07-21'

set @ToDate = '2014-07-22'

select @FromDate

select @ToDate

Does that do what you need?

Mule

Have a look at this article. It'll certainly point you in the right direction.

I did the same, I thought it couldn't be that bad could it?...

Helix

You can use PATINDEX or CHARINDEX to do that.

It was so easy it took at least 20 minutes research to make sure there wasn't a catch. I must have checked half the documentation and writing about page...

Dinghy

I got it wrong because I misinterpreted this line:

When you specify a PRIMARY KEY constraint for a table, the Database Engine enforces data uniqueness by creating a unique index...

Venus

Andy Warren (7/10/2014)

---

BWFC, I can tell you it's been a lot of fun writing them. Not all go well and I learn, and try to remember to listen and not...

Thanks for your reply Andy. I can imagine how difficult it is to create a question from an interesting situation and make it answerable without giving too much away....

Edit because I missed the obvious problem.

This does require you to make the assumption that FileID is probably a numeric of some type, in real life you'd probably get...

Required