Bob Hovious (2/22/2009)

---

When dealing with CTE's, keep in mind that you aren't really specifying a sequence of steps, it just reads that way. The optimizer treats it...

I also fell into the typo trap. So I post to get my point anyway...

I had mentioned:

The @tmpTbl variable has data that I'm using to get the results. In the proc, it's actually a select statement...

How often do we hear that in our profession?

PaulB (1/2/2009)

---

WayneS (1/1/2009)The differential backups are taking about 1-2 seconds, even at the end of the day. This way, I would only need to restore, at most, from 2 backup...

My thought process is that if I did...

The office was closed over the...

Thanks. I had tried this, and it didn't work. But it's working now for me.

DiverKas (12/9/2008)

---

A better solution would be to use Crystal, ActiveReports or any other tool that does not require Excel, to export and format the data in an Excel format. ...

sammesel (12/8/2008)

---

I saw it, and I actuallly ran the code (had to do minor adjustments due case-sensitivity of my SQL installation here). But the code does not retrieve data from...

sammesel (12/8/2008)

---

Nice article, but I'd like to see how to actually work with data, i.e. retrieving data from a table or set of tables - or calling a SP to...

Jeff Moden (12/6/2008)

---

Nice article... I love it when things like this are well laid out and to the point. They key here is not whether some of the "religion"...

The third block of code has a typo:

change the last word to OUTPUT (not OUTUT)

Hey all, don't forget to check out the references in the article. I included a sql script that makes a bunch of stored procedures for handling different aspects of Excel...

Ed (12/5/2008)

---

If I wanted to do this kind of thing server-side I too would look at a server grade component like SA Excelwriter.

With MS Excel, I think if you...