i have three tables A,B,C in which i have datecreated column and status column in all three tables.
Status will be like 'New','Pending' etc.....
I need to show data in the dashboard like
A B C
Count of Overdue -New 100 100 100
Count of Overdue -Pending 200 200 200
Count of Today's-New 200 200 200
Count of Today's-Pending 300 300 300
Total 800 800 800
How can i write stored proc to get values in the above manner? Please help