Jeff Moden (5/22/2008Heh... First off, I never build a Tally table using a While loop except for demonstrating how slow it can be. If you only do it once,...

All right Jeff, I was having fun with your tally table example and trying to think set-based on how to clean up a column that included non-alpha characters. I...

The theory goes that it's either a 'fat finger error' or a 'fat head error', this one was both. Needed to either add a space in my final addition of...

In case anyone else wants to use Jeff's example and is lazy like me:

copy/save as a template (.tql) under C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer--------------------------------------------------------------------

Matt Miller (2/27/2008)

---

Kick a man while he's down ,heh? (just kidding). It would be nice if those going over BOL...

Jeff, BOL says this -

Permissions

Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

If I can't convince almighty DBA to make me either, I'm screwed?...

Thanks to both, 8192 should work. 😀

Trombonist - Jazz Performance. I don't play anymore, but want to get back into jazz piano so I can entertain myself. I always just played for myself anyway, and trombone...

Personally, I prefer responses from folks who are logged in, so you can see who the responder is. Starts the names sticking in your head when you like the response....

Article says "SQLServer 2000 and Windows 2000 ONLY" - will this not work in XP?

lol I've been guilty of something like that. "--I don't know...

I don't write because I don't have any business writing (yet). I'm still absorbing all that knowledge that you folks have sweat blood to gain, and consequently I am reaping...

Luke L (5/5/2008)

---

Additionally, If you are looking to try to push people from paradox to SQL server, look for valid business reasons and ways that you'll be able to provide...

Steve - "Being the "Voice of Microsoft" has a nice ring to it "

Thou blasphemer! May the mighty Bill smite thee with a pox!

Erik Hunter (4/30/2008)

---

Based on my own use of ebooks, the Kindle isn't there yet. I use e-library books. I have a card from the New York Public Library, which has...