I know what you mean, imports can be messy and its helpful to brainstorm about the problems.

One method I like to do is to just get the text imported into...

I don't really know the proper use of split8k but I thought I'd open myself up to ridicule anyways!

Load Jeff Moden's function from http://www.sqlservercentral.com/articles/Tally+Table/72993/, understanding it is up to you...

I'd take the simple approach, use bcp to import into a 5 column staging table, then use T-SQL to select from the 5 column staging table into your destination, that...

What I've done in the past with rows like that is to use all the columns to compose a "key" (although I really don't use sql features like making it...

Golfer22 (5/26/2013)

---

A subquery could run in O(k) time which is very fast. In fact, it could be merely a mathematical operation (e.g., 1+1). But it could run in...

Ed Wagner (5/24/2013)

---

That's really good - thank you.

The Windows SFTP server depends on whatever software you buy and install. We have one here, but I don't administer it. ...

I have put together an sftp job using putty. The nice thing about putty is that while you certainly can install it, you can also just download the zip package...

Sergiy (5/23/2013)

---

That must...

FunkyDexter (5/24/2013)

---

At the risk of either being pulled or diving into a storm (in truth, I suspect and hope, neither:rolleyes:) I've had a brief play with 8 and I'm not...

Stefan Krzywicki (5/24/2013)

---

patrickmcginnis59 10839 (5/24/2013)

---

Stefan Krzywicki (5/24/2013)

---

As far as people being dinosaurs, remember that birds are dinosaurs. Fast, agile and can fly. Not such a bad thing.

With all the changes...

Stefan Krzywicki (5/24/2013)

---

As far as people being dinosaurs, remember that birds are dinosaurs. Fast, agile and can fly. Not such a bad thing.

With all the changes to our understanding of...

dndaughtery (5/22/2013)

---

Im running the following in a batch file

sqlcmd -Q "exec dbo.MySproc" -S "MyServer" -d "MyDatabase"

and Im getting the following error:

Named Pipes Provider: Could not open a connection to SQL...

LOL editted!

lnardozi 61862 (5/22/2013)

---

datetime in v1 was definitely crap. v2 should be better though. That wasn't really my point though - my point is that...

vliet (5/13/2013)

---

Developers think row-based. They cannot work with set-based algorithms. Everyone who tells you otherwise hasn't worked together with developers. LINQ is a beautiful integrated query tool on sets, but...