SELECT * "SessInfo" 

FOREACH row_returned modify row.column based on stored_procedure

quote:

---

Originally posted by X002548

What Stored Procedure?

You can not perform an SELECT and an UPDATE in 1 shot

Maybe if you post some more details about what you are trying to do

---

results = Select * from TABLE

<-----The following logic is in a SP----->
for(results[row];row++)
{
if(Licensed && TurnedOn)
   results[row].Status = OK;
if(!TurnedOn)
   results[row].Status = NOTON;
if(!Licensed)
   results[row].Status = NOTLIC;
}
<----- END SP----->

CREATE OR REPLACE FUNCTION "sp_get_feature_info"(par_devid character varying)
RETURNS "FeatureInfo" AS $$
DECLARE
   _feature_info "FeatureInfo"%ROWTYPE;
BEGIN   
   SELECT * INTO _feature_info
     FROM "FeatureInfo";

   SELECT "sp_get_status"(_feature_info."FeatureID") INTO _feature_info."Status";

   RETURN _feature_info;
END; $$ LANGUAGE 'plpgsql';
ALTER FUNCTION "sp_get_feature_info"(par_devid character varying) OWNER TO "postgres";

quote:

---

Originally posted by GilaMonster

That's PostGreSQL, not T-SQL. What database engine are you using?

--
Gail Shaw
SQL Server MVP

---