i want to display count value from different table based on date.
select count(*) from a where fromdate=@frmdate
select count(*) from b where fromdate=@frmdate
here i was using two different proc. to get the out put.
now i want to get the count value from different table and it will return 2 different count values.
in code behind also i want to get 2 count values and i have to use it for different purposes.
so how to get this in a single stored procedure.
need ur suggetsions with examples...