![](https://i.imgur.com/9UQ54uc.gif"){kind=small}
Chewbaca08
New member
0
0%
Months of Service
0%
Hello, I need to update invoice numbers in a table in MSSQL based on IDStr. I want to query and write the invoice numbers to the invoice number field. Additionally, I want to update the invoice issued field from 0 to 1. I would appreciate your support in providing the query I need. I have tried hard but couldn't succeed, thank you.
IDStr: I need to query 120 numbers in this field to bring the list and update the following fields:
InvoiceIssued: When 120 rows are listed, I want to change the value from 0 to 1 in this field.
InvoiceRefNo: When 120 rows are listed, I need to write the invoice numbers from the Excel I have into this field.
InvoiceIssuedDate: I need to provide a fixed date for this field. Thank you in advance for your support. Have a great day.
IDStr: I need to query 120 numbers in this field to bring the list and update the following fields:
InvoiceIssued: When 120 rows are listed, I want to change the value from 0 to 1 in this field.
InvoiceRefNo: When 120 rows are listed, I need to write the invoice numbers from the Excel I have into this field.
InvoiceIssuedDate: I need to provide a fixed date for this field. Thank you in advance for your support. Have a great day.