I have a SP (SP_GetRecordsFromA) which returns a set of records .
create procedure SP_GetRecordsFromA
select * from TableA between @fdate and @todate
So I need some thing like this in new SP SP_GetAandB
1)select * from tabelB ,( exec SP_GetRecordsFromA '10-09-2010','10-10-2010') as y
2)select count(*) from ( exec SP_GetRecordsFromA '10-09-2010','10-10-2010') as y
How to do this? Or is it possible to call a SP inside SP with parameters ?
View Complete Post