Markets

Gary Varga (7/30/2014)

---

BWFC (7/30/2014)

---

My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub...

My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub made a nominal...

Legs

If it...

I've solved it and it was pretty obvious in the end. My where predicate was excluding the rows with the earlier times from the query because I was only...

Do you know anything about your hardware set up? With the best will in the world, it's going to take a lot longer to run on a 386 than...

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)

---

@BWFC

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