You want the rows you posted to be split instead of imported?

Heh... understood... and I frequently do the same thing if the file is crap...

... but that's not what you asked.

Dave (9/15/2008)

---

Hi John - I could, but would that really be useful here? Useful enough to warrant creating a table full of fake data? Or do you think that the...

I found the URL I was thinking about.

http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspx

I disagree with just about everything he says there. 😉

Sorry for the delay...

Absolutely the easiest way to read a "properly formed" CSV file is using OpenRowSet. If the file is called "ImportTest.csv" and it's stored in "C:\Temp", and...

Glad it helps, Pam. Thanks...

Think of spt_Values as a "config" table for SQL Server. I just happen to know that there's a set of sequential numbers from 0 to 2047 in SQL Server...

Marios Philippopoulos (9/14/2008)

---

Jeff Moden (9/14/2008)

---

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...

dulanjan (9/15/2008)

---

i just cut and paste from your code. (dont worry i left your name on there :D)

so yeah if you put in any consecutive saturday and sunday you get...

jmuldoon (9/15/2008)

---

I would be interested in hearing any argument(s)...

Basically, it's just like what's there already... a bunch of identical tables with different ranges of a column or columns. You create a view using SELECT/UNION just like you...

{said in the same tone that Homer Simpson says "Doooonuuttts"}

Mmmmmmm.... Pork Chops... 😛

Grant Fritchey (9/15/2008)

---

We have our meeting with the CIO on this topic tomorrow. It's a waste of time though because minds are clearly made up. My goal will be to...

That's what I really meant... what were the inputs. Thanks for the 13th/14th of this month. I'll give it a try.

I see that some folks think of the CLR vs T-SQL as a turf war. Gosh, I wish people wouldn't think that. I do wish they'd do some...