I don't know for sure... but I think it's highly unlikely that MySQL will have the same nameing structure convention... never mind a user called "dbo".

SO... what does all of that mean? Did you use Ramesh's solution or not? If not, would you post your solution, please?

Perfect, John...

You give up too soon 😉

[font="Courier New"]DECLARE @CrLf char(2)

SET @CrLf = Char(13) + Char(10)

SELECT COALESCE(NULLIF(Add1,' ') + @CrLf, '') + COALESCE(NULLIF(Add2,' ') + @CrLf, '') + COALESCE(NULLIF(Add3,' ') + @CrLf,...

You bet, Jason... thanks for the feedback...

ps. I hate Oracle 😛

Heh... thanks for the feedback... I actually wrote a cursor once or twice... it was to show how slow they were... 😉

Greg,

I'm working on a couple of work arounds and a full "wish list" to Tony... I'll get back on these formatting issues... just not right now...

Ummm... what's that mean? :blink:

RAGHAVENDRA NARAYANA (11/8/2007)

---

Large volume means number of rows and data size of source(s) that need to be processed into the target system by applying good amount of complex validation/filtration/transformation logics....

Actually, after you asked, I did a bit more testing and I was completely backwards in my statement.

Using the testing code below I got a 3% to 97% comparison.

Where the...

Heh... sounds to me like someone wrote an accidental Cartesian join and decided to wait for it to complete...

First,...

Do you have a script to do this one at a time?

Do you know what *= means?

I just started going through the free chapter... glad to see there's some consideration for writing good code in there... maybe there's more in the rest of the book, but...