Dear Antares686,

Thank you very much for that reference. While it didn't resolve my problem of dropping decimal notation it did get me thinking about the precision and scale issue....

Dear Antares686,

Yes, I'd be glad to post these. Thank you very much for your assistance. The code for the stored procedure follows this, then a bit of explanation...

Thanks! Yes, I read in the books online that @@Identity was quite problematic. I was using IDENT_CURRENT but I see that SCOPE_IDENTITY is the better choice.