Good point!  Thanks for sharing.

Yeah, it's a good question.  I think these things came slowly at different times over time.  And I guess I like structure and routine which maybe some people don't like,...

<!--more-->I've been WFH for eight years. When this all happened it felt like everything around me was changing but nothing was changing for me. And I was fascinated by all...

yes, these are the same. The Load_* tables are supposed to have the Id, EverythingElse fields but the naming can be arbitrary because you would want one for each...

The Load_RN table is referenced in a previous post comment.

The function is purposely missing as mentioned in the article because you may want to calculate your own date.

The RN_Upd table...

I believe you could use this approach for exporting as well. You would be going back the other way in terms of concatenating all your fields together and then...

The format for the table would look like this:

CREATE TABLE [dbo].[Load_RNFile](

[Id] [int] IDENTITY(1,1) NOT NULL,

[EverythingElse] [varchar](500) NULL,

CONSTRAINT [PK_Load_RN] PRIMARY KEY CLUSTERED

(

[Id] ASC

)

) ON [PRIMARY]

GO