Hi All,

After taking into consideration (e.g. variants & possible typos) it will be very difficult to provide a future proof solution. It looks like the best approach will be to...

Hi All,

Thank you for the additional information. I am still trying find a fix regarding what has been variable length of the postcode string. I would welcome any further suggestions.

Thanks...

Hi All,

For now I am unable to "clean" any of these records as doing so will cause problems elsewhere.

Thanks for the suggestions. They assisted me in finding a solution:-

CASE...

Hi All,

I believe that this could be possibly be resolved with a Case Statement?

The select needs to do the following. If there are three separate strings in the column...

Hi,

Most of the records in this column are correct i.e. NN4 0NB (two strings separated with a space), Then occasionally I return corrupt records i.e. Derbyshire S42 5BX (three strings...

Hi,

Just what I needed. Many Thanks! 🙂

Hi,

Thank you to all that have helped me resolve this.

Apologies for the long winded post's. Will attempt to use more screenshots in the future.

Kindest regards to All:-)

Hi,

Please find attached spread sheet showing the correct Running Total values .

Kind regards

Hi,

Please find Sample Table c/w records:-

CREATE TABLE #Temp(

[ROWNUMBER] [float] NULL,

[Component] [float] NULL,

[M/O No] [float] NULL,

[Opening Balance] [float] NULL,

[M/O Qty Req,d (MWOMAT)] [float] NULL,

[Issued to M/O] [float] NULL,

[Running Total] [float]...

Hi,

You shall need to send your text file as attachment using the send mail task (SMT). In the SMT:- MessageSourceType="Direct Input", Attachment=Path & filename of CSV etc. You configure the...

Hi Phil,

Absolutely perfect!!!

I have been struggling with this for a couple of days.

Many Thanks

Hi,

Sorry typo on my part. Address/Town are the same column.

The examples are sample records found in the Address Column.

Thanks

Hi Maxim,

Thankyou for your assistance. I corrected the syntax and was able to update the single record.

My final statement is to updaye as follows:-

UPDATE Target

SET Target.ICSUDO =...

Hi Maxim,

Thanks for finding the typo. I am now using the following statement:-

UPDATE A.ICSUDO

SET A.ICSUDO = B.DELNO

FROM MOVEX.DANIELS.MVXBDTA200.MPLIND A

INNER JOIN GoodsIn.dbo.POIN B

ON A.ICPUNO = B.PUNO

WHERE A.ICWHLO =...