Heh... good point. But have had this argument with many other folks... there's...

Although the "OR" in your example allows each value to be matched and displayed, it does not form a Cartesian product...

DECLARE @TableA TABLE (SNo CHAR(1),ENo INT)

INSERT INTO @TableA (SNo,ENo)

SELECT...

Sure... how many rows in the temp table?

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