I've never seen such an error in SQL Server, so it...

Michael Meierruth (8/20/2008)

---

Michael Meierruth (8/20/2008)

---

I have forgiven myself for not knowing the meaning of that abbreviation. But...

In that case, the path to the spreadsheet should probably be a UNC that the SQL server can see... the reference to C: is for the server and won't work...

Thanks again, Arniban. 🙂

Thanks, Anirban. I appreciate it... 🙂

rog pike (8/20/2008)

---

There's nothing like seeing the latest go around of PMS (pivot madness syndrome). And it seems time after time, year after year, release after release there's a contest...

Chris Morris (8/20/2008)

---

Jeff Moden (8/19/2008)

---

Chris Morris (8/19/2008)

---

Really nice to read, Jeff, and absolutely spot on.

I've had to do pivots in the last couple of weeks, with an unknown number of...

True enough... but if you have enough to physically seperate the data, you won't usually have any RI requirements between the two servers...

pockeyfan (8/19/2008)

---

Hi, thanks for your help

However, I could not run your codes in my system. There's always error message shown "Incorrect syntax near...

Matt Miller (8/15/2008)

---

By the way - that was...

Carl Federl (8/19/2008)

---

Jeff, regarding the benchmark method you are using, found a curious situation.

If this SQL is run, statistics time reports duration and cpu of of zero:

set statistics time on

insert...

Jeff Moden (8/19/2008)

---

Jeffrey Williams (8/19/2008)

---

Jeff Moden (8/19/2008)Yeap... 'bout six weeks ago if I recall correctly... the only thing missing for me was doing those bloody dual Pivots...

Do you...

Jeffrey Williams (8/19/2008)

---

Jeff Moden (8/19/2008)Yeap... 'bout six weeks ago if I recall correctly... the only thing missing for me was doing those bloody dual Pivots...

Do you happen to...

charshman (8/19/2008)

---

No offense Jeff, but I think you're taking the discussion a bit off topic. The original question had nothing to do with cursors as you know them in...

Couple of things may be happening here... first off, where is 'c:\SEND\SPF' ?? If it's not on the server, then you have to change the path to a UNC....