Hi Cadavre,
The following select statement returns over 3000 rows:
SELECT EMPL_UNO, MONTH, PERIOD, BILLABLE_HRS, NONBILL_HRS, ACCOUNTABLE_HRS,
BILLABLE_AMT, NONBILL_AMT, ACCOUNTABLE_AMT, RECEIPT_AMT, LAST_MODIFIED
FROM _TBM_Persnl_Bud_Update
I'm really not certain why they used a Cursor - as I mentioned, I'm new to sql and I am just using an sp that was already written for the purpose of updating the table.
What I'm trying to accomplish is to insert new rows into an existing table: _Tmp_Persnl_Bud. The rows are :EMPL_UNO, MONTH, PERIOD, BILLABLE_HRS, NONBILL_HRS, ACCOUNTABLE_HRS,
BILLABLE_AMT, NONBILL_AMT, ACCOUNTABLE_AMT, RECEIPT_AMT, LAST_MODIFIED
I created a flat file from an excel spreadsheet that was provided to me with the new information and I created a temp table from that. That is where I'm trying to pull the new information from.