Grant Fritchey (9/15/2008)

---

One thing I'm aware of in our organization, and I think it's universal. Object oriented developers loathe TSQL. I've watched blood pressures visibly rise in meetings when the...

Carla Wilson (9/15/2008)

---

Jeff, thanks for that great test script. I like your code for building 1,000,000 row table. I'm saving this code for reference.

Thanks for pointing out how...

Ummmm... wouldn't a nice partitioned view work well here?

Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box or not if you...

Sergiy (9/14/2008)

---

Single quotes are for test strings.

They are not from file, of course. 🙂

And, I believe, there are 7 columns in both strings.

1st one should be split into:

1Pick-up

2

3

41234

52008-08-24

6 "2008-08-24"

717", unknown...

Jack Corbett (9/13/2008)

---

Thanks, Jeff. I actually put a lot more time into the code than the article.

Yeah, I know that it is turned off by default at the...

Heh... yeah, it's an attention getter for sure.

Start by clicking on "Write for us" in the vertical column at the top left of this whole thread. Then, click on...

I think 3 separate directories might be a bit of overkill, but if that works for you, good enough. 🙂

I count 8 columns in the first line and only 7 columns in the second line. Is that correct? And, the single quotes on each end are also...

But, that's the whole problem. Your code is loading the file names of the full files and that's not the right thing to do. Your code should only...

Heh... "Crap happens". 😛

Heh... good analogy... unless you don't realize that you're on the same team.

You guys need to sit down and hammer out your differences, not so that anyone wins but the...

Greig,

When you get a chance... all I need to know is are you splitting a single parameter or do you need to split a whole column of these? If...

Who's that directed to, Mike?

Absolutely... what do you want to do? Split a true CSV parameter or a tru CSV column in a poorly formed table that needs a bit of normalization? ...