Thanks! 😉

Tom Brown (5/27/2009)

---

I have a very similar problem at the moment.

What I'm planning to do is add the linkedserver, then use OPENROWSET to select some data from the access database...

GSquared (5/27/2009)

---

Grant Fritchey (5/27/2009)

---

GilaMonster (5/27/2009)

---

I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and...

What?? If you are talking about your post, not sure if that truly answers my question. Is the OP using the SQL...

Have you tried reading about this in Books Online under the section on SSIS (SQL Server Integration Services)? That would be a very good place to start your research.

Question I have, is what day of the week does your week start on? Need to know that before we can tell you how to determine the starting date...

Jeff Moden (5/27/2009)

---

Damus (5/27/2009)

---

Jeff Moden (5/27/2009)

---

Why don't you just attach it to this thread so the rest of us can take a peek,...

Here is another OMG moment.

Kris (5/27/2009)

---

Sorry guys, but I don't know what sample data would do when it's wrong.....I want every customer that has bought a bicycle and every other purchase too.....if they haven't...

Totally separate rant, but the Dr. Pepper Company really upset me a while ago, they discontinued their Berries and Creme...

"Big Win" is a term that has been overused where I work regarding our getting specific data into an expensive reporting system we purchased.

Have...

GilaMonster (5/27/2009)

---

Grant Fritchey (5/27/2009)

---

Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they...

Are you talking about the "let Me Google That For You" link? Been there, do...

Paul White (5/27/2009)

---

Right then.

Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?

We could all get fabulously rich!!!...