I do something that might be what you want.

In your table above, does RegenerateFlag tell whether that country/vendor should be run?  If so, then you need a process to set...

You know what today is, using GETDATE().  You can use EOMONTH() to get the last day of the current month.  Then use DATEADD to add one day to that.  Save...

• This reply was modified 4 years, 6 months ago by  GaryV. Reason: Clarified comment in code block

I should have gotten it right, except for that critical word "not" that I missed seeing .......

Reminds me of debugging code - we don't see the obvious.

Alphabetical by what?  Table name, or order in the joins?

I suspect the latter.  Which means in one query you might have

Order as a
Join OrderItem as b

And in...

• This reply was modified 4 years, 7 months ago by  GaryV. Reason: Comments on single vs multi-letter aliases

That may not be the OP's fault.  It might be inherited from whenever the tables were created.

I've run across it many times in...

That's why I'm asking people to write...

Not an article, but here's a short outline of what an SSIS package to do this would look like.

• Create a connection manager for the output file, with a generic...

• This reply was modified 4 years, 8 months ago by  GaryV.

Often queries will return the "first" x items.  But just as a query without an ORDER BY doesn't necessarily return the "first" items, neither does STRING_SPLIT always return items in...

Also beware of any queries, views, procedures or reports that use "SELECT * FROM ..." one of these tables you propose to change.

What are the rules for which digits should be kept and which discarded?

Trybbe, what are the results you want to see for your 3 examples?

The issue is confused by the 8 in the 8th position of the last account.  Is that 8...

• This reply was modified 4 years, 10 months ago by  GaryV.
• This reply was modified 4 years, 10 months ago by  GaryV.

You need to define your rules for removing zeroes.  In your first example, you removed 5 of the 6.  In the second, you removed all of them.  How can we...

I'm guessing, even though you say it has the same account and permissions, it has something to do with your connection manager definitions.

That could be due to rights issues -...

I generally like identities as primary and foreign keys, just because that's my preference.  And sometimes it's easier to maintain, say for when the natural key of a collection is...

Use project connection managers for your db connections in the SSIS package.

Deploy the SSIS from your development tool (e.g. Visual Studio) to Integration Services Catalog SSISDB in your dev environment.

Once...