I agree... this one looks like RBAR because it does something for each row... but so do all of the queries built in SQL Server. The difference here...

AnzioBake (12/22/2008)

---

Although I know the value this article can represent you can actually be far more generic than you suggest.

You can write an SP that given the Source Table or...

I don't believe so... I believe you need to setup a new single partition table,...

GilaMonster (12/22/2008)

---

Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database....

timothyawiseman (12/21/2008)

---

So when I have the time, I always think through the set based solution for SQL, but I have no hesitation to just jot out the procedural version one...

I believe you're looking for ALTER TABLE / SWITCH. There's a few caveats to it, but it's all covered in Books Online.

Nah... too much work, Kevin. 😉

So, what is it, supposedly?

Is it actually a unicode file you're trying to import? IF it is, try changing -c to -w in BCP and adding the [font="Arial Black"]DATAFILETYPE = 'widechar'[/font]...

[font="Courier New"]WHILE (1 = 1)

BEGIN

...

...

...

WAITFOR DELAY '0:00:10' --delay 10 seconds

END[/font]

Perhaps it's just me and maybe I'm not getting it, but it looks...

timothyawiseman (12/21/2008)

---

Two things of note though are that it is sometimes faster to code the procedural solution than it is to code the set based one, largely due to habit....

Well, well! Glad to see that the grand misunderstanding as to what is "Set Based" is and is not, prevails. Odd, too, that I've advocated the use of...

It'll work if you put the SELECT LIST into the same order as the COLUMN LIST in the table definition. It would be better if the INSERT had a...

This type of denormalization is not normally a good thing to do in a database... why do you need to do this? What is the purpose?

Now, it's just missing the FROM clause.