i want to select two queries from 1 stored procedure....my following query is correct? and how to call this in 2 gridview
create procedure tablename
 @id varchar(50)
 as
 select a.id,
 isnull(a.advance,0) as advance, 
 isnull(b.submitted_amt,0) as submitted  
 into #temp1
 from 
 (select id,SUM(Amount)as advance
 from table1 where type='Travel' group by id) a 
 full join 
 (select id,SUM(Amount)as submitted_amt
 from table2 group by categeoryid) b 
 on a.id=b.id  
 select id,
 advance,
 submitted,
 advance-submitted as balance_return
 from #temp1
 select categeoryid,advance,submitted,advance-submitted as balance_return from #temp1           id=@id
  
No comments:
Post a Comment