paul.hermans 47816 (1/16/2012)

---

I was trying to figure out how to use a lookup transform, but it doesn't seem obvious.

how would i do that?

It really is a 1 or 2 time...

SQLKnowItAll (1/16/2012)

---

I think that dao's question was whether you can do it without the explicit SPLIT statement. That was the gist of my previous replies: you can alter (redefine)...

SQLKnowItAll (1/16/2012)

---

dao-434438 (1/15/2012)

---

I was wondering if you got the answer to your question about adding new partitions w/o splitting the the range ?

How do you add many partitions to...

paul.hermans 47816 (1/16/2012)

---

I was sort of coming to that conclusion, but am uncertain how to do it.....

Do I make a single derived column that replaces the value of the Gender...

Not exactly the same but very similar, purpotedly from LinkedIn and also marked as spam. Sender's e-mail address was in raw IP...

Yes,...

Forced me to to a bit of searching... Thanks, Steve!

You can ALTER (redefine)( the function and the scheme in one shot, and then use the updated scheme to ALTER table.

Chances are it will be faster than modifying the function...

Jeff Moden (1/15/2012)

---

Then, totally switching gears, are such sample tests actually helping to learn those things necessary to...

"It should be about priority of control, not about order of execution."

Here you have the slickiest of words, "should."

Apparently, it is what it is; for the time being, please try...

You always have to modify the partitioning scheme and ALTER the table. The ALTER statement rejiggles all partitions, whether they already exist or have been just added.

today!

I would get a nice watch and a top-end home audio system and give the rest to my kids.

+1

With me hanging around and promoting it, what is the reputation of the site, anyway? 😉