Also, are you running this code in the Cache database or via a linked server?

Can you please post the code you are running? I know nothing < * using my best Sgt Shultz imitation * > about Cache or how you are accessing...

bigclick (12/23/2009)

---

Yes, it would make sense to have the actual call begin time. Thanks again for your help.

Call Begin Date: 12/03/2009

Call Begin Time: ...

bigclick (12/23/2009)

---

Our vendor was able to give us an example.

Call Begin Date: 12/03/2009

Call Begin Time: -100

Call End Date: 12/04/2009

Call End Time: ...

abcim (12/23/2009)

---

>>Can you answer this: for any one reportID passed into the sproc to retrieve your data, what is the reportID returned by this bit:

... SELECT Top 1 ReportId FROM...

david.tyler (12/22/2009)

---

Before joining the ranks of the IT industry I was 110% involved in music. I played drums for over 20 years starting in the school bands and venturing to...

bigclick (12/22/2009)

---

Good & expected data in TIME_CALL_BEGAN field:

2009-12-15 09:30:19.000

Bad data: -09384593 (note: this is a made up number similar to what we encounter. It...

Jeff Moden (12/22/2009)

---

GSquared (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing...

GilaMonster (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Well you see Steve, Jeff, Barry, Grant, Jack , Gail, Alvin, Bob (active posters in this thread) are all on vacation / holiday mood and no...

CirquedeSQLeil (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Which place are you from...

Bru Medishetty (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Which place are you from...

CirquedeSQLeil (12/22/2009)

---

Hail...

Where do...

Some sample data would help, both good and bad, along with the expected results based on the sample data.

Good to know. Thank you. Have you thought about writing this up as an article for ssc? You should.