Hi Jeff - I used the current sp for now (with the Cursor) - but I am going to look at the alternative that was posted here for the future....

Hello,

I just wanted to update everyone on this issue. I ended up dropping the temp table and recreating it - that seemed to work and everything imported correctly into the...

Hi Karen,

Thank you - I will test that next!

Hi Cadavre,

For some reason I can't get the code to work:( I did run those two select statements.

SELECT COUNT(*)

FROM tbm_persnl_bud a

LEFT OUTER JOIN _TBM_Persnl_Bud_Update b ON a.EMPL_UNO=b.EMPL_UNO AND a.MONTH =...

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

Hi Lowell,

Thank you so much for the example. I like the idea of different colors for the rows. I will play with it some and see what I can do.

This...