Ok so I need to look at my asp code again. Thanks

Apologies in my slow responsiveness - busy work week.

So to elaborate...…

Lets take for example we have a list of customers and each customer has an invoice with maybe ten columns...

oh beautifully done.

Thank you!

I can now start to move my project on!

great i will go with that.

so my final issue with my trailing minus sign is updating all columns that have it in it. I

UPDATE Data_Temp
SET TotalBal =...

ok noted about TEXT - thank you

So would I be good to temporarily store my figure in a VARCHAR(50) ?

Thanks

G

oh one more quick question - what size should I make the VARCHAR datatpe that will hold the decimal value my temp table? Or would TEXT datatype do the job...

OK Phil thank you - I will investigate this. Thanks for your assistance.

• This reply was modified 8 months ago by  kelly.fergus@gmail.com.

I'm not sure. I was thinking of some sort of task scheduler in mssql.

Can I ask how I could achieve notifications of errors during this translation?

ok so i have two tables - first one takes in the values with the trailing minus sign into a VARCHAR datatype. i then run this over the value:

            
March 25, 2024 at 4:02 pm
            
#4401713

            
            
                                                
        

ok guys thank you i will try this out!

Hi Phil,

I export data into a txt file and then i am using the BULK INSERT command.

I was hoping i could find a fix without touching the raw data.

i have...

all sorted thank you guys!!

OH god did i post the ip?

which reply was it?

nothing on cloud side of the VM server - only one section for firewall rules