I believe you can use a UNC there so the file can be on another machine other than the server. But, whatever login the server uses, it must be...

... and, can it be an inline bit of code or do you really need it as a function?

gpspocket (2/25/2009)

---

how to do this ??

mydate= 02/2009

and get like this

fld1 |fld2 |fld3 ...

n_parker (2/25/2009)

---

The datatype is nvarchar(20) for the partnumber and nvarchar(100) for the description - so this works perfectly: SELECT PartNumber + ',' + Description EXCEPT that it has...

RBarryYoung (2/25/2009)

---

Jeff Moden (2/25/2009)

---

I'm going to give up my formatting habits on this forum... from now on, I'm going to post all code with no comments, all upper case, and,...

Hey! By the way, Steve... is there a way to enforce a max width limit on the code windows? Say, at 120 characters so when some of these...

Steve Jones - Editor (2/25/2009)

---

Sorry, Jeff, had to edit that one. Boy that's annoying when someone does that.

Speaking of which....maybe I should make it a development priority to automatically format...

Alright, Ashwin... here's the whole shootin' match including your original posted table except that I included the clustered PK. I've verified that it returns exactly what your code did...

Bob Hovious (2/25/2009)

---

I'm still curious as to why the elapsed times for you (displaying the data) are so dramatically different from the times I get running your code. ...

I absolutely agree with and support...

I'm going to give up my formatting habits on this forum... from now on, I'm going to post all code with no comments, all upper case, and, heh... no spaces......

jcrawf02 (2/25/2009)

---

*sniff *sniff - smells like fish in here. :hehe:

I think perhaps what we're looking for are a couple of questions that need to be answered as part of the...

Steve Jones - Editor (2/25/2009)

---

I like that code, but then Jeff will get upset over the leading commas. I find myself constantly moving his trailers to leaders. Can't someone explain...

GSquared (2/25/2009)

---

Bob Hovious (2/25/2009)

---

Hey G 🙂

It's not barrier to entry. Nobody has to take a test on the material. It's just something that first...

lmu92 (2/25/2009)

---

From my point of view any type of best (or recommended) practice does not need to be mentioned as an "entry requirement for requests" unless there is any "reward"...