I have been trying to write a series of stored procedures which trigger and pass each stored procedure values to complete my select statements.
My First Stored procedure is a query definition in multiple fields.
CREATE PROCEDURE sp_Get_alloc_param AS
Now I tried to create sp_get_alloc_details that issues
CREATE PROCEDURE sp_get_alloc_details
SELECT style, Color, from sodetail
--***This does not work , how can make this work .