JohnSQLServerCentral (5/18/2010)

---

We wrote a report in our application which scripts all the table's data, and then the client uploads the resulting ZIP file it to us. This solution continues...

Good question. It was one of those that I was pretty sure I knew the answer to, but the fact that it was here made me second-guess myself, which...

Workload

No problem. Glad I could help.

Are you, by chance, opening the .csv file using Excel? If so, that explains what you're seeing with the leading zeros being dropped.

Your data contains the leading zeros, so...

I see I'm not the only one who learned something new this morning. Good question that required research. Thanks.

Stuart Davies (4/29/2014)

---

BWFC (4/29/2014)

---

Stuart Davies (4/29/2014)

---

Ed Wagner (4/28/2014)

---

whereisSQL? (4/28/2014)

---

crookj (4/28/2014)

---

BWFC (4/27/2014)

---

rhythmk (4/25/2014)

---

Ed Wagner (4/25/2014)

---

TomThomson (4/25/2014)

---

BWFC (4/25/2014)

---

Stuart Davies (4/25/2014)

---

crookj (4/25/2014)

---

TomThomson (4/25/2014)

---

Ed Wagner (4/25/2014)

---

BWFC (4/25/2014)

---

crookj (4/23/2014)

---

...

whereisSQL? (4/28/2014)

---

crookj (4/28/2014)

---

BWFC (4/27/2014)

---

rhythmk (4/25/2014)

---

Ed Wagner (4/25/2014)

---

TomThomson (4/25/2014)

---

BWFC (4/25/2014)

---

Stuart Davies (4/25/2014)

---

crookj (4/25/2014)

---

refract...

I'm not clear on what you mean by "getting invalid format output in csv file".

However, focusing on the query for a moment:

1. The column name of PURCHASE_DATE doesn't...

Had to do research on something new. Thanks for the question.

Paradigm (shift)

Light

I've had to do it a couple of times myself, but not much. Thanks for an easier question on a Friday.

Thanks for...

DMVs are dynamic management views. They're a collection of views and functions that provide access to internal information about your SQL Server. They're very useful in determining what's...