The double = threw me too. I've never seen it done that way before. But I just got done testing it and it works like a charm!
I did have to make one minor modification to the exact code that Mike posted. I had to declare the @newID variable as an OUTPUT parameter. Now, the line I'm using to call the stored procedure is:
EXEC @errors = gasp_generate 'gasd_case', @newID OUTPUT
Much simpler than what I had come up with! Thanks to you both for your help! I do appreciate it!
- Kile
>>UPDATE gasg_generator
>>SET
>> @newID = id_value = id_value + 1
>
>While this syntax actually work? Mine is written:
>
>SET
>@NewID = id_value + 1
>,id_value = @NewID
>
>BOb