I'm using a single table and I have generated ProfileID (Which is a primary key for the table) in one procedure and now i want to use that same id in another procedure for inserting rest of the table fields. How to call that generated profileID . Query may not be clear but any kind of help is indeed welcomeI'm using a single table and I have generated P