Like to review records incorrectly entered in the database

Question

Like to review records incorrectly entered in the database

Jonathan Brotto 420

We have a database where we enter a record with a number with an alphanumeric suffix. But the software entered it incorrectly due to an algorithm issue which we are trying to fix now but past transactions need to be fixed in the database. If I know the rule says be x+12 for a suffix but just did x could we say the current column does not match what should be? The base number (prefix) is in the database in an independent record as a backup.

Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator

2024-09-24T21:05:38.4666667+00:00

For this type of problem you are making yourself a great feature if you post the CREATE TABLE statement for a test table, and a INSERT statements with sample data together with the expected results. That helps a lot to clarify your description.
LiHongMSFT-4306 31,611 Reputation points

2024-09-25T01:32:06.8366667+00:00

Hi @Jonathan Brotto

It's hard to understand the logic of prefix from your description, can you post some examples for better support.
Jonathan Brotto 420 Reputation points

2024-09-25T20:57:52.37+00:00

My developer just wrote a query where a substring had a certain character to show up in the report as there is an acceptable range. If not in the range of those characters then we had to do an update.
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator

2024-09-25T21:56:13.35+00:00

We didn't ask what happened. We asked for CREATE TABLE, sample data and expected results, so that we can understand the problem, so that we can help you.

Your answer

Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator

2024-09-24T21:05:38.4666667+00:00

For this type of problem you are making yourself a great feature if you post the CREATE TABLE statement for a test table, and a INSERT statements with sample data together with the expected results. That helps a lot to clarify your description.
LiHongMSFT-4306 31,611 Reputation points

2024-09-25T01:32:06.8366667+00:00

Hi @Jonathan Brotto

It's hard to understand the logic of prefix from your description, can you post some examples for better support.
Jonathan Brotto 420 Reputation points

2024-09-25T20:57:52.37+00:00

My developer just wrote a query where a substring had a certain character to show up in the report as there is an acceptable range. If not in the range of those characters then we had to do an update.
Erland Sommarskog 128.3K Reputation points MVP Volunteer Moderator

2024-09-25T21:56:13.35+00:00

We didn't ask what happened. We asked for CREATE TABLE, sample data and expected results, so that we can understand the problem, so that we can help you.

Share via

Like to review records incorrectly entered in the database

Your answer