It sounds like a pretty big ask for a free forum to me, but my advice is you track whatever information you feel is relevant. There is data captured by...

I give it -1 for suggesting a trigger.  My rules with triggers is they can only be used if there is no other way. Put the stock update in...

I'm sure there are a TON of these types of experiences. This and DBA's trying to fix issues that don't really exist. Pinal Dave had a good article recently about...

It is still not working, I tried something similar, I think the issue is that @Period is an integer and @FiveYearAgo is not so if I do the where...

• This reply was modified 1 month, 1 week ago by Mr. Brian Gale.
• This reply was modified 1 month, 1 week ago by Mr. Brian Gale.

That is always a fun thing to find and a fun thing to fix. Loops and row based logic are performance killers for SQL and unfortunately, I don't think any...

I'd also like to add if rn, is_processed, and processed are all frequently used, I'd remove the "magic code" and persist those values to disk; even if they are calculated...

I second this....

• This reply was modified 1 month, 1 week ago by Mr. Brian Gale.

So much out there relies on video and audio. As a deaf person, this is a whole world I struggle to interact with.

As an experiment, turn the sound...

Hi Brian; thanks for the response.

Unfortunately, the [rn] is a pseudo-column from the ROW_NUMBER() window function so I'd have to store the output into a temporary table in order...

As a random guess - I'd say your CSV has some invalid data in it such as a row with an extra/missing comma. This can happen when your CSV allows...

As far as I am aware, there is no way to update a record AND select in a single query, but you could do it all in one transaction or...

Thanks Phil for sharing the alternative to do. I never used VS database project for schema comparison. The idea of creating such script came as there was a requirement...

Why would I need enterprise grade for a one man show? For something he'd run every few weeks?  I'm not processing 100K files an hour.

If you can point out...

That is very strange... If you have a diff tool (such as winmerge), it may help you look at the DTSX and/or DTPROJ files and try to figure out what's...

How about doing it a little differently and instead of:

where  @Period < (select LEFT(CONVERT(varchar(6),DATEADD(yyyy,-5, getdate()),112),6))

you first store the yyyymm in a variable with something like:

            
July 23, 2025 at 4:41 pm
            
#4626247