Something like (make a backup of the table or wrap the update in a transaction so you can roll it back...)

UPDATE EmployeeTable

SET EMailAddress = otherTable.EMail

WHERE EmployeeTable.FieldX = OtherTable.FieldY

Basically, you do...

If you have only one value per month, then you can use LAG([Inventory],1) OVER (ORDER BY DateArchived) AS PrevValue

and then compare. Maybe easier to do it in T-SQL.

Use a Calendar table maybe?

Maybe this will help?

You could use multiple REPLACE functions

use tempdb;
go
CREATE TABLE TheReplacements(
        Search_Value VARCHAR(15) PRIMARY KEY
        , Replace_Value VARCHAR(15) NOT NULL
);
GO
INSERT INTO TheReplacements (Search_Value, Replace_Value)
VALUES ('Timothy','Tim'),('Kathleen','Kathy'),('Joseph','Joe'),('Michael','Mike');
CREATE TABLE People (
 PersonID...

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...