Dave, thank you so much. I was close, but not quite good to go. Such a small thing, such a big difference

Again, Thank...

oh, yeah ... I changed this procedure and added transaction code:

DECLARE @NextCustNo VarChar(10)

-- get new customer number and insert new record

BEGIN TRAN

Select @NextCustNo = NextCustNo FROM TblMisc

Set...

I know, I know ... now. This is a system that is 4 years old and started life as an access database that I ported to SQL Server. It is...

It's fixed ... I had a return before my last select (the one that returns my current values) I pulled out the return and it works.

here is the current code:

create...

Hi

it works 🙂 ... BUT it doesn't return anything. I run it and it says "no recordset returned" what am I missing??

thanks, Lynda

quote: