Guys, thanks for all the responses on my question, I love to see people digging into the engine compartment of the car instead of just saying it’s a “blue car...

I think for formal sites like these, yes use your full names, but if you are on any other site, rather use a nick.

Myself have about 3 years Teradata experience, and SAS of about 6 months, but of about 15 years ago. Of what I remember of SAS, is that what ever you...

Hi guys, thought I would paste some of the performance figures.

I used the following statements each time I ran 1 of the test

CHECKPOINT;

DBCC DROPCLEANBUFFERS;

CREATE NONCLUSTERED INDEX Test1 ON Post_File082_Landline_No...

Attached is the SQL Plan. I could never really understand the plans but hopefully someone will.

the only thing which I can add is that the group by query ranges from...

Pivot table solution on 9.5 mil records returned : 134 seconds

and with first solution 132 seconds.

HI, yes, my original post was to get the value without using a aggregation, but I see that the solution which i'm using includes it in any case! I didnt...

Just to add to my original post, currently using SQL Server Agent, and working really well for the past 3 weeks or so.

Tested it without the sub select, and works perfectly. Thanks!

Thanks I found this on this site, works perfectly

SELECT

ACCT_DEBTOR,

max(LandLineNumber1) as LandLineNumber1,

max(LandLineNumber2) as LandLineNumber2,

max(LandLineNumber3) as LandLineNumber3

FROM (

SELECT

ACCT_DEBTOR,

OCCURRENCE,

(Case WHEN OCCURRENCE=1 THEN...

thansk for the info, Matt. Will check it out

Hi I see that my auto stats was on, I've switch it off now and will see how that goes. Thanks

Hi Grant

Thanks for the reply. I think that you hit the sanil on the head with this 1. I knew if I just explain it, someone will have someone will...

You mentioned that the select of records take 13 mins but the import 120. Have a look at using OLD Destination and set "Data Access mode" to "fast load"

I know,...

Hi Giancarlo

Great to hear it is sorted now. Goes to show that you need to be very careful with the service packs and which ones are installed.