I have a table containing columns (Date , PumpStatus)
Table1:

I have 2 Tables “Transport_Status” and “Receipts” where the id number is the key and can occur in Transport_Status more than once.

I have a table of key-value pairs that I want to pivot.

I have a table of key-value pairs that I want to pivot.

I’m attempting to replicate the issue described in this previous S.O. question, where the goal is to:

Below, I show the tables I am working with and present the problem I am trying to solve.

I’m using the database (SQL Server) of an old program, and want to make batch inserts on the SUPPLIERS table which key is varchar(10). The thing is that the old program fills the key with leading blankspaces to complete the 10 characters, example (underscore represents blankspace)
=’_______310′, ‘_______311’…, ‘______1000’.

I’m using the database (sql server) of an old program, and want to make batch inserts on the SUPPLIERS table which key is varchar(10). The thing is that the old program fills the key with leading blankspaces to complete the 10 characters, example (underscore represents blankspace)
=’_______310′, ‘_______311’…, ‘______1000’.

EmployeeID EffectiveDate EndDate Salary ContractFlag 100 01/01/2022 12/31/2022 10,000 Completed 100 01/01/2023 12/31/2023 20,000 Completed 100 01/01/2024 12/31/2024 30,000 Active 100 01/01/2025 12/31/2025 40,000 Pending 200 01/01/2022 12/31/2022 25,000 Completed 200 01/01/2023 12/31/2023 35,000 Completed 200 01/01/2024 12/31/2024 35,000 Active 200 01/01/2025 12/31/2025 40,000 Pending 300 01/01/2022 12/31/2022 10,000 Completed 300 01/01/2023 12/31/2023 20,000 Completed […]

Say I have a table with orders on it. Those orders have an OrderType column indicating what kind of order it was.