GSquared (8/16/2012)

---

ChrisM@Work (8/16/2012)

---

Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

Not sure of the name though. Symba is a bit silly, it’s a misspelling...

pwalter83 (8/16/2012)

---

ChrisM@Work (8/16/2012)

---

Paul, have you tried these two yet?

WHERE MB.CREATE_DT > = DATEADD(HOUR,-14,GETDATE()-1) -- similar to DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))

WHERE MB.CREATE_DT > = DATEADD(HOUR,0,GETDATE()-1) -- similar to getdate()...

Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

Not sure of the name though. Symba is a bit silly, it’s a misspelling of the...

Earlier this year I had an interview for a gig right next to Swindon station, a dream forty-minute commute compared with the two hours each way I’d been on for...

Paul, have you tried these two yet?

WHERE MB.CREATE_DT > = DATEADD(HOUR,-14,GETDATE()-1) -- similar to DATEADD(D, 0, DATEDIFF(D, 1, GETDATE()))

WHERE MB.CREATE_DT > = DATEADD(HOUR,0,GETDATE()-1) -- similar to getdate() - 1

It's...

GilaMonster (8/16/2012)

---

I suspect it's because of the level and point...

Here's something I knocked up over lunch, shouldn't take long to swap the tally table for Jeff's:

SELECT...

pwalter83 (8/16/2012)

---

ChrisM@Work (8/16/2012)

---

pwalter83 (8/16/2012)

---

Hi,

The query I am working on runs very slow due to a piece of code -

CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1

Could someone please...

GilaMonster (8/16/2012)

---

Paul showed that for a heap (the only case in discussion here), the page is not dirtied and the update log record not written when an update occurs that...

+1

The proofs are educational - but sooner or later someone's conclusions will be...

Please...

Something like this:

SELECT

Company,

AVG_MatchedToSent = AVG(DATEDIFF(hour,Matched_Date, Sent_Date))

FROM YourTable

GROUP BY Company

pwalter83 (8/16/2012)

---

Hi,

The query I am working on runs very slow due to a piece of code -

CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1

Could someone please suggest an...

Hi

You've posted four or five similar questions and as Gail has already pointed...

Hi Don, I can't help with the SSRS issue - however, if you were to choose to do the aggregation and calculations in a query, then I could certainly help...