|
|
Posted by meendar on 05/23/07 06:06
Hi,
Please see the below procedure.
create procedure a1
as
begin
create table #table1
{
empid int;
empname varchar
}
insert into #table1 select empid,empname from employee where
empcode='50'
select e.* from employee e, #table1 as t1 where e.empid=t1.empid and
e.empname=t1.empname; /* query1 */
end
In location query1,empid , empname in #table1 substitutes all the
values at the time, i need to substitute each value individually in
location query1.
Is there any way to do this?
Navigation:
[Reply to this message]
|