For the delimiter issue, I typically try to use delimiters that either...

Believe me, it's not as impressive as it sounds!

tosscrosby (10/25/2010)

---

Ray K (10/25/2010)

---

WOTD: fog

(both literally and figuratively -- I'm looking out my office window, and there are a lot of low-lying clouds, and I haven't had my...

WOTD: fog

(both literally and figuratively -- I'm looking out my office window, and there are a lot of low-lying clouds, and I haven't had my coffee yet!)

Alvin Ramard (10/22/2010)

---

Ray K (10/22/2010)

---

Rather than using SELECT INTO for your second statement, why not just use INSERT INTO?

Edit: looks like Alvin and I are operating on the same wavelength...

Rather than using SELECT INTO for your second statement, why not just use INSERT INTO?

Edit: looks like Alvin and I are operating on the same wavelength today! 🙂

Daniel Bowlin (10/22/2010)

---

For us east coasters, that will be lunch. ...

Tango. Golf. India. Foxtrot.

Edit: my original reply was a bit too flippant -- didn't want anyone to take it the wrong way!

Maybe "overkill" wasn't the right word -- rather,...

Okay, that's what I figured.

I ended up just creating a simple SELECT statement for the column immediately following the INSERT. I'm just writing a quick 'n dirty, and it's...

I remember having all sorts of fun with cardboard boxes when I was a kid! I'd draw wheels and windows on the box, climb into it -- and boom!...

Quack! Honk! Gobble! Cluck!!!

(Translation: "@#$%^&*!!!") :hehe:

I thought about it, but wasn't going to say it!

Anyone have any ideas to help this fellow out? (I don't.)

http://www.sqlservercentral.com/Forums/Topic1008514-391-1.aspx

Good question. I can't think of an answer.

Why do you need to do this? If you tell us what you're trying to achieve, maybe we can come up...