Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
display row even if categories case count = 0
I did create temp categories, cat1 and cat3 tables and did a left outer join, but I still don't see rows for cat3='Canceled'. Also changed Count(*) to count(xxx). Please check my query: Declare @Categories Table ( Categories varchar(50) ) insert into @Categories values('BM') insert into...- ptd1
- Post #3
- Forum: Microsoft SQL Server: Programming
-
display row even if categories case count = 0
I am running this sql quer to get case counts by category per month. This displays a row if case count > 0 for any category for that month. What do I do for it to display a row even if case count = 0 for any category. SELECT CASE AA.DOS.SpecimenType.SpecimenTypeName WHEN 'Bone Marrow' THEN...- ptd1
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
select all check box uncheck
I created this javascript to do two things: 1. check all child checkboxes if select all checkbox is selected. 2. show alert popup if all cases are not complete and user clicks select all checkbox., Both these functionalities are working. When I user clicks the select all checkbox, all the...- ptd1
- Thread
- Replies: 1
- Forum: Javascript
