Thanks for the help, you have solved the problem.

Prefix - Was the data before I received help.

PostFix - What I wanted my end solution to look like

I like your suggestion and thanks for the feedback.

I will create a movie dimension table. I will have a list of the movie text fields. Would you be able to...

Oh sorry, it represents SUBSCRIBER.DAILY_DV_NEW PARTITION

The other table is has some sort of usage which has been aggregated. This is the REVENUE.MONTHLY_VOUCHER_NEW

create table dbo.test_create_2-- creates empty table

(

Report_Monthint,

MSISDNfloat,

Usagefloat

)

insert into...

Its meant to be a combination of two months worth of data.

If an MSISDN is in both months then the final output would be:

Report_Month || MSISDN || SUB_SEGEMNT

201406 || 721312144...

Sure thing...

create table dbo.test_create-- creates empty table

(

Report_Monthint,

MSISDNfloat,

SUB_SEGMENTvarchar(100),

)

insert into dbo.test_create (Report_Month, MSISDN,SUB_SEGMENT)

VALUES (201406,0721312144,'Silver'),

(201406,0521312144,'Silver'),

(201406,0621312144,'Gold'),

(201406,0821312144,'Silver'),

(201406,0921312144,'Silver'),

(201407,0721312144,'Silver'),

(201407,0521312144,'Silver'),

(201407,0621312144,'Gold'),

(201407,0777892144,'Silver'),

(201407,972649133,'Silver')

The final result should only have MSISDN's:

721312144

521312144

621312144

As these are...

That's great! Thanks so much 🙂

Perfect! Thanks a million 🙂

Thanks so much!!! Appreciate the help!!!

Thanks a million for the help everyone! Really appreciate it 🙂

Thanks a million for the help 🙂

Ended up using SSIS and the Fuzzy Lookup algorithm.

Thanks for the help and advice.

John when I run CREATE CLUSTERED INDEX IDX_incident_driver ON MyTable (incident_driver);

I receive this error:

Warning! The maximum key length is 900 bytes. The...

Jcb im no expert but I was told that even though I drop the temp tables they sit in a TempDB and the drive that they sit on is almost...

Thanks for the post Cadavre, that answers my question. I'll read up on what you posted

Hi Chris,

I'm not exactly sure if I understand your question.

AF_Fraud_Jan_24 is the table that will be updated with the additional column. This is a table I created. The other two...