I am using sql 2000:
I need to select some fields from an already defined complex stored procedure.
and then calculate some var based on returns fields from the stored procedure.
i have :
p1=pass parameter1...
stproc(p1,p2,p3) which returns table with field1,field2,field3
I need to create a select which return field1,field3, newfield4
newfield4=based on p2 and p3
How can I do this using a select command
Please advice/Help
Thank you
dre
I need to select some fields from an already defined complex stored procedure.
and then calculate some var based on returns fields from the stored procedure.
i have :
p1=pass parameter1...
stproc(p1,p2,p3) which returns table with field1,field2,field3
I need to create a select which return field1,field3, newfield4
newfield4=based on p2 and p3
How can I do this using a select command
Please advice/Help
Thank you
dre