Oh! I knew it had to be easier than I was making it!

For grins, I wrote this in VB.NET (well, sort of)

Public Function FormattedDate (ByVal dtInputDate As Date, ByVal blnShort As Boolean) As String
    Dim m As Byte
    Dim...

From what I've read, Language is a report-wide setting. So the only way I could think of doing it is to use either SWITCH or a lookup.

I sort of got...

If these are EDI files, then you can't just import them. You have to parse those, because the different lines have different meanings/information. Do they have a consistent structure?

the one upside to certification is that it may cover things you might otherwise miss. On the other hand, be aware that they don't cover everything. (Damned if you, damned...

Depends on what you mean by "closest".  If it doesn't matter if it's over or under, you could use

ABS(DATEDIFF(...))

Why do you have 4 columns that, in theory, contain potential duplicates and lots of nulls? Either I'm missing something, or this is a nonsensical question.

Run this and try it again:

use master;

go

ALTER AUTHORIZATION ON DATABASE::AdventureWorksDW2016 TO [ComputerName\InstanceName];

I had a Visio license for 2000 version (it as a long time ago!) and it could reverse engineer databases. That would work, but it would be really nice to...

Didn't Lowell Aguirre post something on using gmail for this? I think it was several years ago, but should still be applicable.

(Why can't I edit my original response? Hmm...)

Here's the article:

https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function

SELECT test.SomeID, test.SomeValue, split.ItemNumber, Item = QUOTENAME(split.Item,'"')

FROM #JBMTest test

CROSS APPLY dbo.DelimitedSplit8k(test.SomeValue,',') split

WHERE split.ItemNumber = 4;

Use DelimitedSplit8K() and then specify the item# you want to return?

Jeff Moden wrote an article about splitting strings and included a UDF to do it. It returns (Value, Position) so...

Like this?

use tempdb;

GO

-- Now i want to order the KEY Column in products table

use tempdb;
GO
-- Now i want to order the KEY Column in products table
CREATE TABLE...

Can you post real table definitions (even partial)?  It's impossible to answer your question with the current level of detail.

Maybe this article will help.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-–-converting-rows-to-columns-1