Cool! Would you mind posting the code?

Ah... thanks Gus.

BobAtDBS (8/12/2008)

---

Seldom is the answer "never do it this way". It often "depends".

We host a "stock exchange" server for our customers. They trade a lot of documents and...

Grant Fritchey (8/12/2008)

---

That's the old days. Now, most karate...

David Jackson (8/12/2008)

---

I know I'm late to the party, but can anyone point me in the direction of Matt's CLR UDF for regex? I could use it for my...

Thanks for the feedback, Jenny.

GSquared (8/12/2008)

---

Jeff Moden (8/11/2008)

---

...The biggest problem I've seen with Temp Tables is where people do a CREATE or SELECT/INTO in the middle of a query. If you look at...

kiranbgiet (8/11/2008)

---

hello

temporary tables are least in use as they consume the memory resource

Instead of temporary tables you can use the table variable as the table variable is just...

Thanks, Angel. 🙂

Like everything else, it depends... sometimes, neither. 😉

Heh... or taking what I said before... the challenge is to be the Egg and not the Chicken. 😀

Like I said, I've never done it before and your guess is as good as mine... maybe something like...

--===== Write text line to file

CREATE PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varbinary(MAX)) AS

DECLARE...

nwinningham (8/11/2008)

---

How can I get this information to come back in one row?

Thomas Hainey 999999 NULL ...

The answer to the infamous "chicken or the egg" problem is... the egg. A chicken can only be a chicken... it is possible for an egg to become something...

I haven't read all the posts on this thread, but I have to ask... why do you want to return 200k+ rows for anything? :blink: