SQLTeam.com | Weblogs | Forums

Duplicate data in SQL


#1

dear friends,
I have a problem with SQL Server
here's my data


and I wanna erase the value in column InvoiceNetAmount and CustomerNetAmount become Null in second line (yellow), sp there will be only one value in InvoiceNetAmount and CustomerNetAmount

does anyone could help me ?
thank you

Best Regards

Steve Henry


#2

Please provide sample data as CREATE TABLE and INSERT statements so that we do not have to type in the data ourselves.