Viewing 15 posts - 1 through 15 (of 90 total)
Brilliant, thank you very much for your time Des.
January 28, 2022 at 9:13 am
This was removed by the editor as SPAM
January 27, 2022 at 4:49 pm
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.
February 15, 2021 at 11:48 am
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...
June 2, 2020 at 8:38 am
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...
June 1, 2020 at 3:28 pm
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...
June 1, 2020 at 2:20 pm
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...
June 1, 2020 at 1:16 pm
Ahh my mistake. On the email the WHERE N<= 500 part came out as 'WHERE N<= 500' and was giving me an error so I altered it to just 'WHERE...
June 1, 2020 at 1:06 pm
Yes,that's right Neil. It's only returning 1 row but I need 500 rows as you have shown
Thank you
Paul.
June 1, 2020 at 1:01 pm
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
June 1, 2020 at 12:52 pm
Ahhhh that's much better for me.
Thank you Chris.
April 9, 2020 at 3:20 pm
Thank you Frederico.
April 9, 2020 at 10:34 am
Thank you. My intention was if any of the fields were = 40 then update them to zero. I used the single update statements as suggested by Mike in the...
November 6, 2019 at 3:05 pm
Oh, I see. Haha, just me trying to be clever
Thank you for your help Mike. I'll go with the simple option.
November 5, 2019 at 3:44 pm
Yes, thanks John. I've done that now.
Anyone have any idea how or why some columns ended up different collation to the others and to the default collation of the server...
August 9, 2019 at 2:13 pm
Viewing 15 posts - 1 through 15 (of 90 total)