Basically you'll need to use a format file that maps the fields from your source file to the specific columns in the target table if the number/order of columns isn't...

So as long as your...

I remember many developers calling them "memory tables".

The worst aspect of why people used table variables was that the Microsoft Best Practices Analyzer suggested they do so. At the...

Datetime/Datetime2 are not specifically anything, just are a date and a time.  And yes as you saw with your issue converting from a datetime to a datetimeoffset does not preserve...

When you let it do the implicit conversion of anchor date it's setting the it to UTC time zone not converting, 2022-02-18 00:00:00.0000000 +00:00.

Which is actually less than 2022-02-17 20:22:47.8048644...

Failed to specific whether it's a leap year or not.

Why not move the parsing out of SQL?  Parse the raw files in something else first(powershell, C# whatever) and dump them into the table structure needed then load from those?

>>>>Eirikur Eiriksson wrote: >>>Grant Fritchey wrote:

>>Sean Lange wrote:

>And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a...

Not a language necessarily but it's definitely high time i learn how to really use git.  We're starting to really use it and i need to be able to troubleshoot...

What part are you having trouble with?  Creating the connection string for prompting for the password?

Well have you identified which queries are actually running to create those missing index statistics?  You would then need to see how expensive those queries actually are beyond just they...

Is that quote still applicable to your business? I wonder how many businesses have started to see new trends and needed to abandon some amount of historical data from their...

What's wrong with just?

COL_ONE = COL_TWO AND COL_ONE=COL_THREE etc....

Any other "clever" solution is almost certainly going to be more code.

Do you mean you have some package you created in the wizard in SSMS and you want to move it to SSDT?

I think there is no "one size fits all" solution, but I would also argue that with web-based content changes should be handled by the business, and not by one...