nrajasekhar7
asked on
How to disaply the count zero for missing record
Hi All
I am having two tables
Table A location_index,Date ,location...etc
Table B: Location_Index,location_de sc ...etc
There are some missing Records in the Location for particular dates in given month
so how to write the query to display the missing record as zero in the out put:
For ex:
date Location
1/10/2010 6
2/10/2010 8
3/10/2010 0
4/10/2010 9
5/10/2010 0
means if there is a record on that day for the location it should that value else should display zero. Data base is SQL Server.
Front end query desing using Crystal reports.
Please Help!!!
Thanks & Regards
Raj.
I am having two tables
Table A location_index,Date ,location...etc
Table B: Location_Index,location_de
There are some missing Records in the Location for particular dates in given month
so how to write the query to display the missing record as zero in the out put:
For ex:
date Location
1/10/2010 6
2/10/2010 8
3/10/2010 0
4/10/2010 9
5/10/2010 0
means if there is a record on that day for the location it should that value else should display zero. Data base is SQL Server.
Front end query desing using Crystal reports.
Please Help!!!
Thanks & Regards
Raj.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27807
mlmcc