Gkhadka (12/22/2009)

---

CriquedeSQL... I think you missunderstood the question above. I think he is saying that he installed SQL 2008 and SSIS on one server (let it be a DEV box)....

First, I'm glad this is a SQL Server 2005 forum. Here is a possible solution, but how you implement it is all up to you since you haven't provided...

Not a problem posting your code. It actually is different than was suggested before. It is always good to post your final solution. Others may benefit, so...

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