SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,075 questions
Like to review records incorrectly entered in the database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
420
Reputation points
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.
{count} votes
-
Erland Sommarskog 113.1K Reputation points MVP2024-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 28,806 Reputation points2024-09-25T01:32:06.8366667+00:00 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 113.1K Reputation points MVP
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.
Sign in to comment
Sign in to answer