Hi All

I want to make store the result of a query into the variables. i.e. I columnnames needed to be stored a the variables. All this is to be done in a Stored Procedure.

Example

Select SaveDate, IsLocked from tblname where <condition>

I need to store SaveDate & Islocked in the variables for further use in store procedure.

The query always returns single row at a time.

Looking 4 ur help
Thanx in Advance.

Plz send your code if you can.