Thank you Grant.

Yes, that's not an issue for me, there's nothing connected to my database at the moment but I will keep that in mind for the future.

Just trying to...

Great, thank you.

Thank you for your reply Ant.

That's a tough one for me, my boss set the database up in azure. I believe it 'Azure SQL DB' because it doesn't allow me...

I think I've got it now....

update Conversion.dbo.chargebreaks 
set chargeguid = dest.chargeguid
from conversion.dbo.charge as dest inner join
speedlink.dbo.chargebreaks as source on 
dest.chargeid = source.chargeid

Hi Phil,

Yes, thank you. I've got it sorted now. I've gone with the INSERT INTO, SELECT route now.

Cheers

Paul.

Brilliant, thank you very much for your time Des.

Hi GroverVivek,

Thank you. I realised I was going about it the wrong way and have now resolved my issue.

Thank you for taking the time to help.

Kind regards

Paul.

Unfortunately it's not as black and white as that Jeff.

This is just one surcharge for one customer. We have many different customers that can have upwards of 30 different surcharges...

Hi Jeff,

I'll give you a bit of background to it all.

We have a customer that is charging 0.28p per kilo as a surcharge for international shipments.

The issue is that our...

Well I can see the first 3 rows are representing the tens, hundreds and thousands of the figure and I assume the cross join is what puts them side by...

Do you know the syntax for me adding it to the insert into statement please Neil?

I'm trying like this, the chargeid would be 2218, the upper and lower are obtained...

Ahh my mistake. On the email the WHERE N<= 500 part came out as 'WHERE N&lt;= 500' and was giving me an error so I altered it to just 'WHERE...

Yes,that's right Neil. It's only returning 1 row but I need 500 rows as you have shown

Thank you

Paul.

Thanks Neil, unfortunately not. It just gives back the numbers 499.01 for lower and 500.00 for upper but I need the numbers from 1.00 onwards

Thank you

Paul