InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:39:34 GMT20http://www.sqlservercentral.com/Forums/Topic1409648-391-1.aspx[quote][b]smriti.subramanian (1/22/2013)[/b][hr]Table structure:create table Aid1 int,status intdate created datetime...[/quote]I tried running this in SSMS and it didn't parse. If only we had some valid DDL. Oh well...Tue, 22 Jan 2013 06:59:03 GMTtoddasdhttp://www.sqlservercentral.com/Forums/Topic1409648-391-1.aspxTable structure:create table Aid1 int,status intdate created datetimetable Bid2 intstatus intdate created datetimetable c id3 intstatus intdate created datetimetable statusiddescriptionThe description field will be like pending, new etc...i need the output as mentioned above..Tue, 22 Jan 2013 02:21:44 GMTsmriti.subramanianhttp://www.sqlservercentral.com/Forums/Topic1409648-391-1.aspxThe "easiest to understand" type of solution is to build a temp table exactly like you want the output to look. Then have individual queries gather the pieces of information and update the temp table as you go along. All of these queries can be wrapped as one in a stored procedure. It's not hard, you just have to break it down into manageable chunks. What have you tried so far? Mon, 21 Jan 2013 14:39:52 GMTtoddasdhttp://www.sqlservercentral.com/Forums/Topic1409648-391-1.aspxCan you please provide us the table structure so that we can try to solve your problem?Its good practice to provide detailed information so that everyone can understand problem that your are facing.....Mon, 21 Jan 2013 11:38:52 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic1409648-391-1.aspxhi,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 CCount of Overdue -New 100 100 100Count of Overdue -Pending 200 200 200Count of Today's-New 200 200 200Count of Today's-Pending 300 300 300Total 800 800 800How can i write stored proc to get values in the above manner? Please helpMon, 21 Jan 2013 10:42:49 GMTsmriti.subramanian