Hi Naveen, welcome to the forum.

To help we're going to need a little bit more detail. When you say you're trying to retrieve them, what do you mean? ...

Cold

hoseam (7/21/2014)

The code is this:

declare @ToDate datetime

declare @FromDate datetime

set @FromDate = '01/02/20014'

set @ToDate = '28/02/20014'

SELECT EVENTDATE,'' AS BRANCHCD, BUSINESS_AREA, CREATE_DATE, WORK_TYPE, QUEUE, STATUS, CREATE_AGE, CATEGORYCD, DELAYREASON1,...

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)

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