You don't need the subselect:

SELECT

ACCT_DEBTOR,

MAX(Case WHEN OCCURRENCE=1 THEN LANDLINE_CONTACT_NO ELSE null END) AS LandLineNumber1,

MAX(Case WHEN OCCURRENCE=2 THEN LANDLINE_CONTACT_NO ELSE null END) AS LandLineNumber2,

MAX(Case WHEN OCCURRENCE=3 THEN LANDLINE_CONTACT_NO ELSE null...

I'd collect the data in a comma separated list (comma on fixed position, e.g. every 10th character) up to a size of approx. 4k (resulting in 400 values), pass that...

Ok, you told us the number and size of the tables you're using. You also provided almost 200 lines of code.

What exactly is your question / expectation?

Also, since this looks...

I hope I didn't scare away the newbie on this thread with my Tally table joke... But I HAD to do it... :hehe:

Please have a look at Jeff's Tally table article[/url].

At the very end of the article, shortly before the conclusion paragraph, you'll find a short and efficient example of making a...

Hi Rohit,

as already mentioned by Wayne you should let us know what your expected result looks like. It will help us to help you. Otherwise you'll get results that might...

I'll take the fact of less points on my side than him as an excuse to...

I was on my way to provide an "alternative"...

Objection, Your Honor! One dove doesn't make a summer.;-)

But thanx for the flowers! 🙂

SELECT LEFT(acct_id,1) + '000' + RIGHT(acct_id,3),

email_alert_stub,

email,

ROW_NUMBER() OVER(ORDER BY email DESC) AS seq

FROM TEST

Attached please find a solution based on

Jeff's article[/url].

I had to make some changes to your sample data:

1) I changed @transaction to a temp table #transaction in order...

@paul-2: The PM's I sent you just made one thing clear to me: I'm addicted to SSC. I stared...

I'm just waiting for the clarification regarding the handling of 'partial transaction'.

Other than that, the code is ready to post.

Even if I might get it right I wouldn't consider myself...

For our non-German fellows: Duden has nothing to do with "Dude", it actually is a dictionary that contains all the words that are supposed to be part of the German...

As another German around I'd have to -slightly- disagree with Flo.

"GUI" actually is not really German (Graphical User Interface, right?) 😀

So it would be something like "Bildlicher-Benutzer-Oberflaechen-Unsinn", or "BBO-Quatsch". whereas...