Advanced Search

Return to Snippet

Revision: 17682
at September 11, 2009 12:45 by lonergan123
Initial Code 
SELECT Allergen1.Code, Allergen1.TypeCode, Allergen1.Description, Allergen1.ExternalDrugCode, Counts.AllergyCount
FROM CV3Allergen Allergen1
INNER JOIN
        (SELECT Allergen.GUID, Count(NULLIF(Allergy.AllergenGUID,0)) AllergyCount
        FROM CV3Allergen Allergen
        LEFT JOIN CV3AllergyDeclaration Allergy
        ON Allergy.AllergenGUID = Allergen.GUID
  AND Allergy.Status = 'Active'
  AND Allergen.TypeCode IN ('Drug', 'Drug Category')
        GROUP BY Allergen.GUID) Counts
ON Allergen1.GUID = Counts.GUID
ORDER BY 5 DESC, 1
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Return counts for each drug / drug category allergen

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Allergy / Allergen Counts

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL