Just a  thought, and probably not a very good one.   But in lieu of status flags validating rows, or exclusion tables.   Why not remove suspect/invalid rows to other tables with...

BUT, within the context of the same transaction you see the changes prior to the commit.

(Used a temp table here because table variables,  like all variables, retain their current values...

Here is an illustration that may help.    Note that both columns don't wind up with the original value of V2 until the update   ends (commits).

declare @table...

GUIDS are big, fat and ugly...   they bloat indexes.   😀

Try googling "State Geographies Downloads".

Also, keep in mind that airlines and ships follow a great circle route between ports.   Over long distances, pythagorean theorem (straight-line geometry) calculations won't work for...

Might be easier if you showed us a couple of examples of values for Var1Title, Var1Topic, and Var1Name... and what you expect the result to be.   🙂

I would like to echo Brian's comments.    Improving SQL code depends on an understanding of the data, the execution plan, the table and index structures, etc.     Given enough...

The solution seems much simpler, once you look at the data sorted by startdate and enddate within each IdentityID.    A gap only occurs when the current start date is...

• This reply was modified 3 years, 9 months ago by  The Dixie Flatline. Reason: Had the wrong version of code. TotalDays wasn't calculated correctly

1. Copy your data into a staging table.
2. Replace all opening square brackets "[" and quote marks with space(0) to make your string look like this:

   1613347200,7],1613347205,6],1613347210,7]

3. Replace all close square...

• This reply was modified 3 years, 9 months ago by  The Dixie Flatline.

Since you are sorting by OpNum within WONum, your "last occurrence" is the same thing as the maximum value of OpNum.  You even stated it was the "highest value."   So....

If the file name always starts with the string "Feed_" you can build the file name in a variable and pass it instead of a constant.

DECLARE @fileExists...

Conceptually, you must always remember that CASE is an expression, not a statement.   You use it just as you would use a function, or a formula, to deliver a single...

I agree that you aren't specific about what to do when the first three characters are something like N2X.     What if you have the string 'N2XY45689'?    Do you...

The world has more than it's share of ignorant, irresponsible people.    All the rest of us can do is try to minimize the impact they have.    Hope all...

Yes, I missed the concept.   I was simply keying off the PASSOB column.   I'll go back and re-read more carefully. Apologies.