Hello Matt -

The gridkey is a sequence key required by the application, and it is obtained from a grid sequencing table. Many keys in the application come from such...

Thanks also for this tidbit - now that I have the process working, I can play around with options and refinements!

Really appreciate all your help.

Kenena

Hello Jason -

mrpolecate was able to add to the assist you gave me this morning, and I just want to say thanks so much for your time. This will...

Thanks for the help, mrpolecat. I made the suggested changes and after changing to While @@Fetch_status <> -1, it ran successfully. I can't tell you what this means...

The table TRAINING$ has only 60 rows, each has an employee id identifier and they happen to be unique here.

Thanks for your help, I appreciate it.

Hello Jason -

I made the suggested change, but I am still getting multiple entries of the first row. Any other suggestions on that?

Thanks,

Kenena

Thanks, Jason.

That would be fine in the case of this particular table, as it was added by me as allowed by the application, but the other application tables cannot be...

Hi Jason -

Thanks for your reply. My application has a lot of these sequence tables. This SP can be used to call the next sequence from whichever table...

my apology

Thanks for your help, but I am receiving the error message that data type of TEXT is invalid for the function

The comments field is like the following: