Database

jkirkerx wrote:

INSERT INTO [proj_cost] ( Proj_ID, Proj_Stage, Vers_ID, Task_ID, Task_Oper, Task_Class, Vend_ID, CO_Proj_Type, CO_Type, CO_Type_D, CO_Value, Cost, ADD_NO, ADD_DATE, ADD_CODE, Pref_Vendor, User_Last_Upd, Delete_Flag ) VALUES ( '2549', 'engineering', '0', 'TK_AT_001', '85', 'OP', '', '39', 'PoolSpa', 'REF_AT_002', '', '25', '175', '0', '1900-01-01 00:00:00.000', '', 'jimk', 0 )

$result2 = sqlsrv_query($conn, $query2) or die(" setDbProjectCost " . LINE . " - " . $query2 . " - " . print_r(sqlsrv_errors()));
if (sqlsrv_has_rows($result2)) {
    $row2 = sqlsrv_fetch_array($result2);
    $addDateString = $row2[13]->format('Y-m-d H:i:s') . '.000';

    $query3 = "
    DECLARE @addDate AS VARCHAR(33) = '$addDateString';
    INSERT INTO [proj_cost] 
    VALUES ... @addDate

SELECT * FROM table1, table 2 WHERE table1.id = table2.id;

SELECT [TABLE_NAME]
      ,[COLUMN_NAME]
  FROM [INFORMATION_SCHEMA].[COLUMNS]
  where TABLE_NAME = <your_temp_view>

sys.columns (Transact-SQL) - SQL Server | Microsoft Docs[^]:

Column IDs might not be sequential.

SELECT [name], ROW_NUMBER() OVER (ORDER BY [column_id]) As [Ordinal]
FROM sys.columns
WHERE [object_id] = OBJECT_ID('MyTable')
ORDER BY [column_id]