Help with taking this script from primitive to dynamic

Question

Post reply

Help with taking this script from primitive to dynamic

pharmkittie

SSCertifiable

Points: 5775
More actions
February 23, 2014 at 8:22 pm

#396308

I've been working on what is me a difficult problem for days and have managed to make it give the results I need but it is an embarrassing kludge. I hope someone will help me out so that I can learn how to do it better next time. I've tried to shorten up the scripts by taking the middle lines out (they're repetitive) but it's still a lot of code. Thanks in advance for looking through it!
Here's a table of the possible combinations of specialties and capabilities (the 'YES' column should be ignored):specialtycapnumbercapforthisspecialty
Allergy1_1YES
Allergy1_2YES
Allergy1_3YES
Allergy1_4YES
Allergy1_5YES
Allergy1_6YES
Allergy1_7YES
Allergy1_8YES
Allergy2_1YES
Allergy2_2YES
Allergy2_3YES
Allergy2_4YES
Allergy2_5YES
Allergy2_6YES
Allergy2_7YES
Allergy2_8YES
Allergy2_9YES
Allergy3_1YES
Allergy3_2YES
Allergy3_3YES
Allergy3_4YES
Allergy3_5YES
Allergy3_8YES
Allergy4_1YES
Allergy4_2YES
Allergy4_3YES
Allergy4_4YES
Allergy4_5YES
Allergy4_6YES
Allergy4_7YES
Allergy4_8YES
Allergy4_9YES
Allergy5_1YES
Allergy5_2YES
Allergy5_3YES
Allergy5_4YES
Allergy5_5YES
Allergy5_6YES
Allergy5_7YES
Allergy5_9YES
Allergy6_1YES
Allergy6_2YES
Allergy6_3YES
Allergy6_4YES
Allergy6_5YES
Allergy6_6YES
Allergy6_7YES
Allergy6_8YES
Allergy6_9YES
Allergy8_4YES
Allergy8_7YES
Allergy9_1YES
Allergy9_2YES
Allergy9_3YES
Allergy9_4YES
Allergy9_5YES
Allergy9_6YES
Allergy9_8YES
Allergy10_1YES
Allergy10_2YES
Allergy10_3YES
Allergy10_4YES
Allergy10_5YES
Allergy10_6YES
Allergy10_7YES
Allergy10_8YES
Allergy11_1YES
Allergy11_2YES
Allergy11_3YES
Allergy11_4YES
Allergy11_5YES
Allergy11_6YES
Allergy11_8YES
Allergy12_1YES
Allergy12_2YES
Allergy12_3YES
Allergy12_4YES
Allergy12_5YES
Allergy12_6YES
Allergy12_7YES
Allergy12_8YES
Allergy12_9YES
Allergy13_1YES
Allergy13_2YES
Allergy13_3YES
Allergy13_4YES
Allergy13_5YES
Allergy13_6YES
Allergy13_7YES
Allergy13_8YES
Allergy13_9YES
Allergy14_1YES
Allergy14_2YES
Allergy14_3YES
Allergy14_4YES
Allergy14_5YES
Allergy14_6YES
Allergy14_7YES
Allergy14_8YES
Allergy14_9YES
Allergy2_13YES
Allergy2_14YES
Allergy4_11YES
Allergy4_12YES
Allergy4_13YES
Allergy4_14YES
Allergy4_15YES
Allergy4_16YES
Allergy12_11YES
Allergy12_12YES
Cardiology1_1YES
Cardiology1_2YES
Cardiology1_3YES
Cardiology1_4YES
Cardiology1_5YES
Cardiology1_6YES
Cardiology1_7YES
Cardiology1_8YES
Cardiology2_1YES
Cardiology2_2YES
Cardiology2_3YES
Cardiology2_4YES
Cardiology2_5YES
Cardiology2_6YES
Cardiology2_7YES
Cardiology2_8YES
Cardiology2_9YES
Cardiology3_1YES
Cardiology3_2YES
Cardiology3_3YES
Cardiology3_4YES
Cardiology3_5YES
Cardiology3_8YES
Cardiology4_1YES
Cardiology4_2YES
Cardiology4_3YES
Cardiology4_4YES
Cardiology4_5YES
Cardiology4_6YES
Cardiology4_7YES
Cardiology4_8YES
Cardiology4_9YES
Cardiology5_1YES
Cardiology5_2YES
Cardiology5_3YES
Cardiology5_4YES
Cardiology5_5YES
Cardiology5_6YES
Cardiology5_7YES
Cardiology5_9YES
Cardiology6_1YES
Cardiology6_2YES
Cardiology6_3YES
Cardiology6_4YES
Cardiology6_5YES
Cardiology6_6YES
Cardiology6_7YES
Cardiology6_8YES
Cardiology6_9YES
Cardiology8_4YES
Cardiology8_7YES
Cardiology9_1YES
Cardiology9_2YES
Cardiology9_3YES
Cardiology9_4YES
Cardiology9_5YES
Cardiology9_6YES
Cardiology9_7YES
Cardiology9_8YES
Cardiology10_1YES
Cardiology10_2YES
Cardiology10_3YES
Cardiology10_4YES
Cardiology10_5YES
Cardiology10_6YES
Cardiology10_7YES
Cardiology10_8YES
Cardiology11_1YES
Cardiology11_2YES
Cardiology11_3YES
Cardiology11_4YES
Cardiology11_5YES
Cardiology11_6YES
Cardiology11_8YES
Cardiology12_1YES
Cardiology12_2YES
Cardiology12_3YES
Cardiology12_4YES
Cardiology12_5YES
Cardiology12_6YES
Cardiology12_7YES
Cardiology12_8YES
Cardiology12_9YES
Cardiology13_1YES
Cardiology13_2YES
Cardiology13_3YES
Cardiology13_4YES
Cardiology13_5YES
Cardiology13_6YES
Cardiology13_7YES
Cardiology13_8YES
Cardiology13_9YES
Cardiology14_1YES
Cardiology14_2YES
Cardiology14_3YES
Cardiology14_4YES
Cardiology14_5YES
Cardiology14_6YES
Cardiology14_7YES
Cardiology14_8YES
Cardiology14_9YES
Cardiology2_11YES
Cardiology2_12YES
Cardiology2_13YES
Cardiology2_14YES
Cardiology3_11YES
Cardiology3_12YES
Cardiology4_11YES
Cardiology4_12YES
Cardiology4_13YES
Cardiology4_14YES
Cardiology4_15YES
Cardiology4_16YES
Cardiology4_18YES
Cardiology12_11YES
Cardiology12_12YES
Critical Care1_1YES
Critical Care2_1YES
Critical Care2_3YES
Critical Care2_5YES
Critical Care2_8YES
Critical Care2_9YES
Critical Care3_1YES
Critical Care3_3YES
Critical Care3_4YES
Critical Care3_5YES
Critical Care4_1YES
Critical Care4_3YES
Critical Care4_4YES
Critical Care4_7YES
Critical Care5_1YES
Critical Care5_3YES
Critical Care5_4YES
Critical Care5_5YES
Critical Care5_6YES
Critical Care5_9YES
Critical Care6_1YES
Critical Care6_2YES
Critical Care6_3YES
Critical Care6_4YES
Critical Care6_5YES
Critical Care6_6YES
Critical Care6_7YES
Critical Care6_8YES
Critical Care6_9YES
Critical Care8_4YES
Critical Care8_7YES
Critical Care9_5YES
Critical Care9_6YES
Critical Care9_8YES
Critical Care10_1YES
Critical Care10_2YES
Critical Care10_3YES
Critical Care10_4YES
Critical Care10_5YES
Critical Care10_6YES
Critical Care12_1YES
Critical Care12_2YES
Critical Care13_1YES
Critical Care13_2YES
Critical Care13_4YES
Critical Care13_5YES
Critical Care13_6YES
Critical Care13_7YES
Critical Care13_8YES
Critical Care13_9YES
Critical Care2_12YES
Critical Care2_13YES
Critical Care3_12YES
Critical Care4_16YES
Critical Care4_18YES
Emergency
Medicine1_1YES
Emergency
Medicine2_1YES
Emergency
Medicine2_3YES
Emergency
Medicine2_5YES
Emergency
Medicine2_8YES
Emergency
Medicine2_9YES
Emergency
Medicine3_1YES
Emergency
Medicine3_3YES
Emergency
Medicine3_4YES
Emergency
Medicine3_5YES
Emergency
Medicine4_1YES
Emergency
Medicine4_3YES
Emergency
Medicine4_4YES
Emergency
Medicine4_7YES
Emergency
Medicine5_1YES
Emergency
Medicine5_3YES
Emergency
Medicine5_4YES
Emergency
Medicine5_5YES
Emergency
Medicine5_6YES
Emergency
Medicine5_9YES
Emergency
Medicine6_1YES
Emergency
Medicine6_2YES
Emergency
Medicine6_3YES
Emergency
Medicine6_4YES
Emergency
Medicine6_5YES
Emergency
Medicine6_6YES
Emergency
Medicine6_7YES
Emergency
Medicine6_8YES
Emergency
Medicine6_9YES
Emergency
Medicine8_4YES
Emergency
Medicine8_7YES
Emergency
Medicine9_5YES
Emergency
Medicine9_6YES
Emergency
Medicine9_8YES
Emergency
Medicine10_1YES
Emergency
Medicine10_2YES
Emergency
Medicine10_3YES
Emergency
Medicine10_4YES
Emergency
Medicine10_5YES
Emergency
Medicine10_6YES
Emergency
Medicine12_1YES
Emergency
Medicine12_2YES
Emergency
Medicine13_1YES
Emergency
Medicine13_4YES
Emergency
Medicine13_5YES
Emergency
Medicine14_1YES
Emergency
Medicine14_9YES
Emergency
Medicine2_13YES
Emergency
Medicine4_16YES
Endocrinology1_1YES
Endocrinology1_2YES
Endocrinology1_3YES
Endocrinology1_5YES
Endocrinology1_6YES
Endocrinology1_7YES
Endocrinology1_8YES
Endocrinology2_1YES
Endocrinology2_2YES
Endocrinology2_3YES
Endocrinology2_4YES
Endocrinology2_5YES
Endocrinology2_6YES
Endocrinology2_7YES
Endocrinology2_8YES
Endocrinology2_9YES
Endocrinology3_1YES
Endocrinology3_2YES
Endocrinology3_3YES
Endocrinology3_4YES
Endocrinology3_5YES
Endocrinology3_6YES
Endocrinology3_8YES
Endocrinology4_1YES
Endocrinology4_2YES
Endocrinology4_3YES
Endocrinology4_4YES
Endocrinology4_5YES
Endocrinology4_6YES
Endocrinology4_7YES
Endocrinology4_8YES
Endocrinology4_9YES
Endocrinology5_1YES
Endocrinology5_2YES
Endocrinology5_3YES
Endocrinology5_4YES
Endocrinology5_5YES
Endocrinology5_6YES
Endocrinology5_7YES
Endocrinology5_9YES
Endocrinology6_1YES
Endocrinology6_2YES
Endocrinology6_3YES
Endocrinology6_4YES
Endocrinology6_5YES
Endocrinology6_6YES
Endocrinology6_7YES
Endocrinology6_8YES
Endocrinology6_9YES
Endocrinology8_4YES
Endocrinology8_7YES
Endocrinology9_1YES
Endocrinology9_2YES
Endocrinology9_3YES
Endocrinology9_4YES
Endocrinology9_5YES
Endocrinology9_6YES
Endocrinology9_7YES
Endocrinology9_8YES
Endocrinology10_1YES
Endocrinology10_2YES
Endocrinology10_3YES
Endocrinology10_4YES
Endocrinology10_5YES
Endocrinology10_6YES
Endocrinology10_7YES
Endocrinology10_8YES
Endocrinology11_1YES
Endocrinology11_2YES
Endocrinology11_3YES
Endocrinology11_4YES
Endocrinology11_5YES
Endocrinology11_6YES
Endocrinology11_8YES
Endocrinology12_1YES
Endocrinology12_2YES
Endocrinology12_3YES
Endocrinology12_4YES
Endocrinology12_5YES
Endocrinology12_6YES
Endocrinology12_7YES
Endocrinology12_8YES
Endocrinology12_9YES
Endocrinology13_1YES
Endocrinology13_2YES
Endocrinology13_3YES
Endocrinology13_4YES
Endocrinology13_5YES
Endocrinology13_6YES
Endocrinology13_7YES
Endocrinology13_8YES
Endocrinology13_9YES
Endocrinology14_1YES
Endocrinology14_2YES
Endocrinology14_3YES
Endocrinology14_4YES
Endocrinology14_5YES
Endocrinology14_6YES
Endocrinology14_7YES
Endocrinology14_8YES
Endocrinology14_9YES
Endocrinology2_13YES
Endocrinology2_14YES
Endocrinology2_17YES
Endocrinology4_11YES
Endocrinology4_12YES
Endocrinology4_13YES
Endocrinology4_14YES
Endocrinology4_15YES
Endocrinology4_16YES
Endocrinology4_18YES
Endocrinology12_11YES
Gastroenterology1_1YES
Gastroenterology1_2YES
Gastroenterology1_3YES
Gastroenterology1_4YES
Gastroenterology1_5YES
Gastroenterology1_6YES
Gastroenterology1_7YES
Gastroenterology1_8YES
Gastroenterology2_1YES
Gastroenterology2_2YES
Gastroenterology2_3YES
Gastroenterology2_4YES
Gastroenterology2_5YES
Gastroenterology2_6YES
Gastroenterology2_7YES
Gastroenterology2_8YES
Gastroenterology2_9YES
Gastroenterology3_1YES
Gastroenterology3_2YES
Gastroenterology3_3YES
Gastroenterology3_4YES
Gastroenterology3_5YES
Gastroenterology3_8YES
Gastroenterology4_1YES
Gastroenterology4_2YES
Gastroenterology4_3YES
Gastroenterology4_4YES
Gastroenterology4_5YES
Gastroenterology4_6YES
Gastroenterology4_7YES
Gastroenterology4_8YES
Gastroenterology4_9YES
Gastroenterology5_1YES
Gastroenterology5_2YES
Gastroenterology5_3YES
Gastroenterology5_4YES
Gastroenterology5_5YES
Gastroenterology5_6YES
Gastroenterology5_7YES
Gastroenterology5_9YES
Gastroenterology6_1YES
Gastroenterology6_2YES
Gastroenterology6_3YES
Gastroenterology6_4YES
Gastroenterology6_5YES
Gastroenterology6_6YES
Gastroenterology6_7YES
Gastroenterology6_8YES
Gastroenterology6_9YES
Gastroenterology8_4YES
Gastroenterology8_7YES
Gastroenterology9_1YES
Gastroenterology9_2YES
Gastroenterology9_4YES
Gastroenterology9_5YES
Gastroenterology9_6YES
Gastroenterology9_7YES
Gastroenterology9_8YES
Gastroenterology10_1YES
Gastroenterology10_2YES
Gastroenterology10_3YES
Gastroenterology10_4YES
Gastroenterology10_5YES
Gastroenterology10_6YES
Gastroenterology10_7YES
Gastroenterology10_8YES
Gastroenterology12_1YES
Gastroenterology12_2YES
Gastroenterology12_3YES
Gastroenterology12_4YES
Gastroenterology12_5YES
Gastroenterology12_6YES
Gastroenterology12_7YES
Gastroenterology12_8YES
Gastroenterology12_9YES
Gastroenterology13_1YES
Gastroenterology13_2YES
Gastroenterology13_3YES
Gastroenterology13_4YES
Gastroenterology13_5YES
Gastroenterology13_6YES
Gastroenterology13_7YES
Gastroenterology13_8YES
Gastroenterology13_9YES
Gastroenterology14_1YES
Gastroenterology14_2YES
Gastroenterology14_3YES
Gastroenterology14_4YES
Gastroenterology14_5YES
Gastroenterology14_6YES
Gastroenterology14_7YES
Gastroenterology14_8YES
Gastroenterology14_9YES
Gastroenterology2_11YES
Gastroenterology2_13YES
Gastroenterology2_14YES
Gastroenterology4_11YES
Gastroenterology4_12YES
Gastroenterology4_13YES
Gastroenterology4_14YES
Gastroenterology4_15YES
Gastroenterology4_16YES
Gastroenterology4_18YES
Gastroenterology12_11YES
Gastroenterology12_12YES
Infectious
Disease1_1YES
Infectious
Disease1_2YES
Infectious
Disease1_3YES
Infectious
Disease1_4YES
Infectious
Disease1_5YES
Infectious
Disease1_6YES
Infectious
Disease1_7YES
Infectious
Disease1_8YES
Infectious
Disease2_1YES
Infectious
Disease2_2YES
Infectious
Disease2_3YES
Infectious
Disease2_4YES
Infectious
Disease2_5YES
Infectious
Disease2_6YES
Infectious
Disease2_7YES
Infectious
Disease2_8YES
Infectious
Disease2_9YES
Infectious
Disease3_1YES
Infectious
Disease3_2YES
Infectious
Disease3_3YES
Infectious
Disease3_4YES
Infectious
Disease3_5YES
Infectious
Disease3_8YES
Infectious
Disease4_1YES
Infectious
Disease4_2YES
Infectious
Disease4_3YES
Infectious
Disease4_4YES
Infectious
Disease4_5YES
Infectious
Disease4_6YES
Infectious
Disease4_7YES
Infectious
Disease4_8YES
Infectious
Disease4_9YES
Infectious
Disease5_1YES
Infectious
Disease5_2YES
Infectious
Disease5_3YES
Infectious
Disease5_4YES
Infectious
Disease5_5YES
Infectious
Disease5_6YES
Infectious
Disease5_7YES
Infectious
Disease5_9YES
Infectious
Disease6_1YES
Infectious
Disease6_2YES
Infectious
Disease6_3YES
Infectious
Disease6_4YES
Infectious
Disease6_5YES
Infectious
Disease6_6YES
Infectious
Disease6_7YES
Infectious
Disease6_8YES
Infectious
Disease6_9YES
Infectious
Disease8_4YES
Infectious
Disease8_7YES
Infectious
Disease9_4YES
Infectious
Disease9_5YES
Infectious
Disease9_6YES
Infectious
Disease9_8YES
Infectious
Disease10_1YES
Infectious
Disease10_2YES
Infectious
Disease10_3YES
Infectious
Disease10_4YES
Infectious
Disease10_5YES
Infectious
Disease10_6YES
Infectious
Disease10_7YES
Infectious
Disease10_8YES
Infectious
Disease11_1YES
Infectious
Disease11_2YES
Infectious
Disease11_3YES
Infectious
Disease11_4YES
Infectious
Disease11_5YES
Infectious
Disease11_6YES
Infectious
Disease11_8YES
Infectious
Disease12_1YES
Infectious
Disease12_2YES
Infectious
Disease12_3YES
Infectious
Disease12_4YES
Infectious
Disease12_5YES
Infectious
Disease12_6YES
Infectious
Disease12_7YES
Infectious
Disease12_8YES
Infectious
Disease12_9YES
Infectious
Disease13_1YES
Infectious
Disease13_2YES
Infectious
Disease13_3YES
Infectious
Disease13_4YES
Infectious
Disease13_5YES
Infectious
Disease13_6YES
Infectious
Disease13_7YES
Infectious
Disease13_8YES
Infectious
Disease13_9YES
Infectious
Disease14_1YES
Infectious
Disease14_2YES
Infectious
Disease14_3YES
Infectious
Disease14_4YES
Infectious
Disease14_5YES
Infectious
Disease14_6YES
Infectious
Disease14_7YES
Infectious
Disease14_8YES
Infectious
Disease14_9YES
Infectious
Disease2_13YES
Infectious
Disease4_11YES
Infectious
Disease4_12YES
Infectious
Disease4_13YES
Infectious
Disease4_14YES
Infectious
Disease4_15YES
Infectious
Disease4_16YES
Infectious
Disease4_18YES
Infectious
Disease12_11YES
Infectious
Disease12_12YES
Neonatal
Care1_1YES
Neonatal
Care2_1YES
Neonatal
Care2_3YES
Neonatal
Care2_4YES
Neonatal
Care2_5YES
Neonatal
Care2_8YES
Neonatal
Care2_9YES
Neonatal
Care3_1YES
Neonatal
Care3_3YES
Neonatal
Care3_4YES
Neonatal
Care3_5YES
Neonatal
Care4_1YES
Neonatal
Care4_2YES
Neonatal
Care4_3YES
Neonatal
Care4_4YES
Neonatal
Care4_6YES
Neonatal
Care4_7YES
Neonatal
Care4_8YES
Neonatal
Care5_1YES
Neonatal
Care5_2YES
Neonatal
Care5_3YES
Neonatal
Care5_4YES
Neonatal
Care5_5YES
Neonatal
Care5_6YES
Neonatal
Care5_9YES
Neonatal
Care6_1YES
Neonatal
Care6_2YES
Neonatal
Care6_3YES
Neonatal
Care6_4YES
Neonatal
Care6_5YES
Neonatal
Care6_6YES
Neonatal
Care6_7YES
Neonatal
Care6_8YES
Neonatal
Care6_9YES
Neonatal
Care8_4YES
Neonatal
Care8_7YES
Neonatal
Care9_5YES
Neonatal
Care9_6YES
Neonatal
Care9_8YES
Neonatal
Care10_1YES
Neonatal
Care10_2YES
Neonatal
Care10_3YES
Neonatal
Care10_4YES
Neonatal
Care10_5YES
Neonatal
Care10_6YES
Neonatal
Care12_1YES
Neonatal
Care12_2YES
Neonatal
Care13_1YES
Neonatal
Care13_2YES
Neonatal
Care13_3YES
Neonatal
Care13_4YES
Neonatal
Care13_5YES
Neonatal
Care13_6YES
Neonatal
Care13_7YES
Neonatal
Care13_8YES
Neonatal
Care13_9YES
Neonatal
Care2_13YES
Neonatal
Care4_12YES
Neonatal
Care4_13YES
Neonatal
Care4_14YES
Neonatal
Care4_16YES
Neonatal
Care4_17YES
Neonatal
Care4_18YES
Nephrology1_1YES
Nephrology1_2YES
Nephrology1_3YES
Nephrology1_4YES
Nephrology1_5YES
Nephrology1_6YES
Nephrology1_7YES
Nephrology1_8YES
Nephrology2_1YES
Nephrology2_2YES
Nephrology2_3YES
Nephrology2_4YES
Nephrology2_5YES
Nephrology2_6YES
Nephrology2_7YES
Nephrology2_8YES
Nephrology2_9YES
Nephrology3_1YES
Nephrology3_2YES
Nephrology3_3YES
Nephrology3_4YES
Nephrology3_5YES
Nephrology3_8YES
Nephrology4_1YES
Nephrology4_2YES
Nephrology4_3YES
Nephrology4_4YES
Nephrology4_5YES
Nephrology4_6YES
Nephrology4_7YES
Nephrology4_8YES
Nephrology4_9YES
Nephrology5_1YES
Nephrology5_2YES
Nephrology5_3YES
Nephrology5_4YES
Nephrology5_5YES
Nephrology5_6YES
Nephrology5_7YES
Nephrology5_9YES
Nephrology6_1YES
Nephrology6_2YES
Nephrology6_3YES
Nephrology6_4YES
Nephrology6_5YES
Nephrology6_6YES
Nephrology6_7YES
Nephrology6_8YES
Nephrology6_9YES
Nephrology8_4YES
Nephrology8_7YES
Nephrology9_1YES
Nephrology9_2YES
Nephrology9_4YES
Nephrology9_5YES
Nephrology9_6YES
Nephrology9_7YES
Nephrology9_8YES
Nephrology10_1YES
Nephrology10_2YES
Nephrology10_3YES
Nephrology10_4YES
Nephrology10_5YES
Nephrology10_6YES
Nephrology10_7YES
Nephrology10_8YES
Nephrology11_1YES
Nephrology11_2YES
Nephrology11_3YES
Nephrology11_4YES
Nephrology11_5YES
Nephrology11_6YES
Nephrology11_8YES
Nephrology12_1YES
Nephrology12_2YES
Nephrology12_3YES
Nephrology12_4YES
Nephrology12_5YES
Nephrology12_6YES
Nephrology12_7YES
Nephrology12_8YES
Nephrology12_9YES
Nephrology13_1YES
Nephrology13_2YES
Nephrology13_3YES
Nephrology13_4YES
Nephrology13_5YES
Nephrology13_6YES
Nephrology13_7YES
Nephrology13_8YES
Nephrology13_9YES
Nephrology14_1YES
Nephrology14_2YES
Nephrology14_3YES
Nephrology14_4YES
Nephrology14_5YES
Nephrology14_6YES
Nephrology14_7YES
Nephrology14_8YES
Nephrology14_9YES
Nephrology2_13YES
Nephrology2_14YES
Nephrology2_16YES
Nephrology4_11YES
Nephrology4_12YES
Nephrology4_13YES
Nephrology4_14YES
Nephrology4_15YES
Nephrology4_16YES
Nephrology4_18YES
Nephrology12_11YES
Nephrology12_12YES
Neurology1_1YES
Neurology1_2YES
Neurology1_3YES
Neurology1_4YES
Neurology1_5YES
Neurology1_6YES
Neurology1_7YES
Neurology1_8YES
Neurology2_1YES
Neurology2_2YES
Neurology2_3YES
Neurology2_4YES
Neurology2_5YES
Neurology2_6YES
Neurology2_7YES
Neurology2_8YES
Neurology2_9YES
Neurology3_1YES
Neurology3_2YES
Neurology3_3YES
Neurology3_4YES
Neurology3_5YES
Neurology3_8YES
Neurology4_1YES
Neurology4_2YES
Neurology4_3YES
Neurology4_4YES
Neurology4_5YES
Neurology4_6YES
Neurology4_7YES
Neurology4_8YES
Neurology4_9YES
Neurology5_1YES
Neurology5_2YES
Neurology5_3YES
Neurology5_4YES
Neurology5_5YES
Neurology5_6YES
Neurology5_7YES
Neurology5_9YES
Neurology6_1YES
Neurology6_2YES
Neurology6_3YES
Neurology6_4YES
Neurology6_5YES
Neurology6_6YES
Neurology6_7YES
Neurology6_8YES
Neurology6_9YES
Neurology8_4YES
Neurology8_7YES
Neurology9_1YES
Neurology9_2YES
Neurology9_4YES
Neurology9_5YES
Neurology9_6YES
Neurology9_7YES
Neurology9_8YES
Neurology10_1YES
Neurology10_2YES
Neurology10_3YES
Neurology10_4YES
Neurology10_5YES
Neurology10_6YES
Neurology10_7YES
Neurology10_8YES
Neurology11_1YES
Neurology11_2YES
Neurology11_3YES
Neurology11_4YES
Neurology11_5YES
Neurology11_6YES
Neurology11_8YES
Neurology12_1YES
Neurology12_2YES
Neurology12_3YES
Neurology12_4YES
Neurology12_5YES
Neurology12_6YES
Neurology12_7YES
Neurology12_8YES
Neurology12_9YES
Neurology13_1YES
Neurology13_2YES
Neurology13_3YES
Neurology13_4YES
Neurology13_5YES
Neurology13_6YES
Neurology13_7YES
Neurology13_8YES
Neurology13_9YES
Neurology14_1YES
Neurology14_2YES
Neurology14_3YES
Neurology14_4YES
Neurology14_5YES
Neurology14_6YES
Neurology14_7YES
Neurology14_8YES
Neurology14_9YES
Neurology2_13YES
Neurology2_14YES
Neurology4_11YES
Neurology4_12YES
Neurology4_13YES
Neurology4_14YES
Neurology4_15YES
Neurology4_16YES
Neurology4_18YES
Neurology12_11YES
Neurology12_12YES
Obsterics
Gyn1_1YES
Obsterics
Gyn1_2YES
Obsterics
Gyn1_3YES
Obsterics
Gyn1_4YES
Obsterics
Gyn1_5YES
Obsterics
Gyn1_6YES
Obsterics
Gyn1_7YES
Obsterics
Gyn1_8YES
Obsterics
Gyn2_1YES
Obsterics
Gyn2_2YES
Obsterics
Gyn2_3YES
Obsterics
Gyn2_4YES
Obsterics
Gyn2_5YES
Obsterics
Gyn2_6YES
Obsterics
Gyn2_7YES
Obsterics
Gyn2_8YES
Obsterics
Gyn2_9YES
Obsterics
Gyn3_1YES
Obsterics
Gyn3_2YES
Obsterics
Gyn3_3YES
Obsterics
Gyn3_4YES
Obsterics
Gyn3_5YES
Obsterics
Gyn3_7YES
Obsterics
Gyn3_8YES
Obsterics
Gyn4_1YES
Obsterics
Gyn4_2YES
Obsterics
Gyn4_3YES
Obsterics
Gyn4_4YES
Obsterics
Gyn4_5YES
Obsterics
Gyn4_6YES
Obsterics
Gyn4_7YES
Obsterics
Gyn4_8YES
Obsterics
Gyn4_9YES
Obsterics
Gyn5_1YES
Obsterics
Gyn5_2YES
Obsterics
Gyn5_3YES
Obsterics
Gyn5_4YES
Obsterics
Gyn5_5YES
Obsterics
Gyn5_6YES
Obsterics
Gyn5_7YES
Obsterics
Gyn5_9YES
Obsterics
Gyn6_1YES
Obsterics
Gyn6_2YES
Obsterics
Gyn6_3YES
Obsterics
Gyn6_4YES
Obsterics
Gyn6_5YES
Obsterics
Gyn6_6YES
Obsterics
Gyn6_7YES
Obsterics
Gyn6_8YES
Obsterics
Gyn6_9YES
Obsterics
Gyn8_4YES
Obsterics
Gyn8_7YES
Obsterics
Gyn9_1YES
Obsterics
Gyn9_2YES
Obsterics
Gyn9_3YES
Obsterics
Gyn9_4YES
Obsterics
Gyn9_5YES
Obsterics
Gyn9_6YES
Obsterics
Gyn9_7YES
Obsterics
Gyn9_8YES
Obsterics
Gyn9_9YES
Obsterics
Gyn10_1YES
Obsterics
Gyn10_2YES
Obsterics
Gyn10_3YES
Obsterics
Gyn10_4YES
Obsterics
Gyn10_5YES
Obsterics
Gyn10_6YES
Obsterics
Gyn10_7YES
Obsterics
Gyn10_8YES
Obsterics
Gyn11_1YES
Obsterics
Gyn11_2YES
Obsterics
Gyn11_3YES
Obsterics
Gyn11_4YES
Obsterics
Gyn11_5YES
Obsterics
Gyn11_6YES
Obsterics
Gyn11_8YES
Obsterics
Gyn12_1YES
Obsterics
Gyn12_2YES
Obsterics
Gyn12_3YES
Obsterics
Gyn12_4YES
Obsterics
Gyn12_5YES
Obsterics
Gyn12_6YES
Obsterics
Gyn12_7YES
Obsterics
Gyn12_8YES
Obsterics
Gyn12_9YES
Obsterics
Gyn13_1YES
Obsterics
Gyn13_2YES
Obsterics
Gyn13_3YES
Obsterics
Gyn13_4YES
Obsterics
Gyn13_5YES
Obsterics
Gyn13_6YES
Obsterics
Gyn13_7YES
Obsterics
Gyn13_8YES
Obsterics
Gyn13_9YES
Obsterics
Gyn14_1YES
Obsterics
Gyn14_2YES
Obsterics
Gyn14_3YES
Obsterics
Gyn14_4YES
Obsterics
Gyn14_5YES
Obsterics
Gyn14_6YES
Obsterics
Gyn14_7YES
Obsterics
Gyn14_8YES
Obsterics
Gyn14_9YES
Obsterics
Gyn2_13YES
Obsterics
Gyn2_14YES
Obsterics
Gyn4_11YES
Obsterics
Gyn4_12YES
Obsterics
Gyn4_13YES
Obsterics
Gyn4_14YES
Obsterics
Gyn4_15YES
Obsterics
Gyn4_16YES
Obsterics
Gyn4_18YES
Obsterics
Gyn12_11YES
Obsterics
Gyn12_12YES
Oncology1_1YES
Oncology1_2YES
Oncology1_3YES
Oncology1_4YES
Oncology1_5YES
Oncology1_6YES
Oncology1_7YES
Oncology1_8YES
Oncology2_1YES
Oncology2_2YES
Oncology2_3YES
Oncology2_4YES
Oncology2_5YES
Oncology2_6YES
Oncology2_7YES
Oncology2_8YES
Oncology2_9YES
Oncology3_1YES
Oncology3_2YES
Oncology3_3YES
Oncology3_4YES
Oncology3_5YES
Oncology3_8YES
Oncology4_1YES
Oncology4_2YES
Oncology4_3YES
Oncology4_4YES
Oncology4_5YES
Oncology4_6YES
Oncology4_7YES
Oncology4_8YES
Oncology4_9YES
Oncology5_1YES
Oncology5_2YES
Oncology5_3YES
Oncology5_4YES
Oncology5_5YES
Oncology5_6YES
Oncology5_7YES
Oncology5_9YES
Oncology6_1YES
Oncology6_2YES
Oncology6_3YES
Oncology6_4YES
Oncology6_5YES
Oncology6_6YES
Oncology6_7YES
Oncology6_8YES
Oncology6_9YES
Oncology8_4YES
Oncology8_7YES
Oncology9_1YES
Oncology9_4YES
Oncology9_5YES
Oncology9_6YES
Oncology9_8YES
Oncology10_1YES
Oncology10_2YES
Oncology10_3YES
Oncology10_4YES
Oncology10_5YES
Oncology10_6YES
Oncology10_7YES
Oncology10_8YES
Oncology11_1YES
Oncology11_2YES
Oncology11_3YES
Oncology11_4YES
Oncology11_5YES
Oncology11_6YES
Oncology11_8YES
Oncology12_1YES
Oncology12_2YES
Oncology12_3YES
Oncology12_4YES
Oncology12_5YES
Oncology12_6YES
Oncology12_7YES
Oncology12_8YES
Oncology12_9YES
Oncology13_1YES
Oncology13_2YES
Oncology13_3YES
Oncology13_4YES
Oncology13_5YES
Oncology13_6YES
Oncology13_7YES
Oncology13_8YES
Oncology13_9YES
Oncology14_1YES
Oncology14_2YES
Oncology14_3YES
Oncology14_4YES
Oncology14_5YES
Oncology14_6YES
Oncology14_7YES
Oncology14_8YES
Oncology14_9YES
Oncology2_13YES
Oncology4_11YES
Oncology4_12YES
Oncology4_13YES
Oncology4_14YES
Oncology4_15YES
Oncology4_16YES
Oncology4_17YES
Oncology4_18YES
Oncology12_11YES
Oncology12_12YES
Orthopedics1_1YES
Orthopedics1_2YES
Orthopedics1_3YES
Orthopedics1_4YES
Orthopedics1_5YES
Orthopedics1_6YES
Orthopedics1_7YES
Orthopedics1_8YES
Orthopedics2_1YES
Orthopedics2_2YES
Orthopedics2_3YES
Orthopedics2_4YES
Orthopedics2_5YES
Orthopedics2_6YES
Orthopedics2_7YES
Orthopedics2_8YES
Orthopedics2_9YES
Orthopedics3_1YES
Orthopedics3_2YES
Orthopedics3_3YES
Orthopedics3_4YES
Orthopedics3_5YES
Orthopedics3_8YES
Orthopedics4_1YES
Orthopedics4_2YES
Orthopedics4_3YES
Orthopedics4_4YES
Orthopedics4_5YES
Orthopedics4_6YES
Orthopedics4_7YES
Orthopedics4_8YES
Orthopedics4_9YES
Orthopedics5_1YES
Orthopedics5_2YES
Orthopedics5_3YES
Orthopedics5_4YES
Orthopedics5_5YES
Orthopedics5_6YES
Orthopedics5_7YES
Orthopedics5_9YES
Orthopedics6_1YES
Orthopedics6_2YES
Orthopedics6_3YES
Orthopedics6_4YES
Orthopedics6_5YES
Orthopedics6_6YES
Orthopedics6_7YES
Orthopedics6_8YES
Orthopedics6_9YES
Orthopedics8_4YES
Orthopedics8_7YES
Orthopedics9_1YES
Orthopedics9_4YES
Orthopedics9_5YES
Orthopedics9_6YES
Orthopedics9_7YES
Orthopedics9_8YES
Orthopedics10_1YES
Orthopedics10_2YES
Orthopedics10_3YES
Orthopedics10_4YES
Orthopedics10_5YES
Orthopedics10_6YES
Orthopedics10_7YES
Orthopedics10_8YES
Orthopedics12_1YES
Orthopedics12_2YES
Orthopedics12_3YES
Orthopedics12_4YES
Orthopedics12_5YES
Orthopedics12_6YES
Orthopedics12_7YES
Orthopedics12_8YES
Orthopedics12_9YES
Orthopedics13_1YES
Orthopedics13_2YES
Orthopedics13_3YES
Orthopedics13_4YES
Orthopedics13_5YES
Orthopedics13_6YES
Orthopedics13_7YES
Orthopedics13_8YES
Orthopedics13_9YES
Orthopedics14_1YES
Orthopedics14_2YES
Orthopedics14_3YES
Orthopedics14_4YES
Orthopedics14_5YES
Orthopedics14_6YES
Orthopedics14_7YES
Orthopedics14_8YES
Orthopedics14_9YES
Orthopedics2_13YES
Orthopedics4_11YES
Orthopedics4_12YES
Orthopedics4_13YES
Orthopedics4_14YES
Orthopedics4_15YES
Orthopedics4_16YES
Orthopedics4_18YES
Orthopedics12_11YES
Orthopedics12_12YES
Otolaryngology1_1YES
Otolaryngology1_2YES
Otolaryngology1_3YES
Otolaryngology1_4YES
Otolaryngology1_5YES
Otolaryngology1_6YES
Otolaryngology1_7YES
Otolaryngology1_8YES
Otolaryngology2_1YES
Otolaryngology2_2YES
Otolaryngology2_3YES
Otolaryngology2_4YES
Otolaryngology2_5YES
Otolaryngology2_6YES
Otolaryngology2_7YES
Otolaryngology2_8YES
Otolaryngology2_9YES
Otolaryngology3_1YES
Otolaryngology3_2YES
Otolaryngology3_3YES
Otolaryngology3_4YES
Otolaryngology3_5YES
Otolaryngology3_8YES
Otolaryngology4_1YES
Otolaryngology4_2YES
Otolaryngology4_3YES
Otolaryngology4_4YES
Otolaryngology4_5YES
Otolaryngology4_6YES
Otolaryngology4_7YES
Otolaryngology4_8YES
Otolaryngology4_9YES
Otolaryngology5_1YES
Otolaryngology5_2YES
Otolaryngology5_3YES
Otolaryngology5_4YES
Otolaryngology5_5YES
Otolaryngology5_6YES
Otolaryngology5_7YES
Otolaryngology5_9YES
Otolaryngology6_1YES
Otolaryngology6_2YES
Otolaryngology6_3YES
Otolaryngology6_4YES
Otolaryngology6_5YES
Otolaryngology6_6YES
Otolaryngology6_7YES
Otolaryngology6_8YES
Otolaryngology6_9YES
Otolaryngology8_4YES
Otolaryngology8_7YES
Otolaryngology9_1YES
Otolaryngology9_4YES
Otolaryngology9_5YES
Otolaryngology9_6YES
Otolaryngology9_8YES
Otolaryngology10_1YES
Otolaryngology10_2YES
Otolaryngology10_3YES
Otolaryngology10_4YES
Otolaryngology10_5YES
Otolaryngology10_6YES
Otolaryngology10_7YES
Otolaryngology10_8YES
Otolaryngology12_1YES
Otolaryngology12_2YES
Otolaryngology12_3YES
Otolaryngology12_4YES
Otolaryngology12_5YES
Otolaryngology12_6YES
Otolaryngology12_7YES
Otolaryngology12_8YES
Otolaryngology12_9YES
Otolaryngology13_1YES
Otolaryngology13_2YES
Otolaryngology13_3YES
Otolaryngology13_4YES
Otolaryngology13_5YES
Otolaryngology13_6YES
Otolaryngology13_7YES
Otolaryngology13_8YES
Otolaryngology13_9YES
Otolaryngology14_1YES
Otolaryngology14_2YES
Otolaryngology14_3YES
Otolaryngology14_4YES
Otolaryngology14_5YES
Otolaryngology14_6YES
Otolaryngology14_7YES
Otolaryngology14_8YES
Otolaryngology14_9YES
Otolaryngology2_13YES
Otolaryngology4_11YES
Otolaryngology4_12YES
Otolaryngology4_13YES
Otolaryngology4_14YES
Otolaryngology4_15YES
Otolaryngology4_16YES
Otolaryngology4_18YES
Otolaryngology12_11YES
Otolaryngology12_12YES
Pain
Mngt1_1YES
Pain
Mngt1_2YES
Pain
Mngt1_3YES
Pain
Mngt1_4YES
Pain
Mngt1_5YES
Pain
Mngt1_6YES
Pain
Mngt1_7YES
Pain
Mngt1_8YES
Pain
Mngt2_1YES
Pain
Mngt2_2YES
Pain
Mngt2_3YES
Pain
Mngt2_4YES
Pain
Mngt2_5YES
Pain
Mngt2_7YES
Pain
Mngt2_8YES
Pain
Mngt2_9YES
Pain
Mngt3_1YES
Pain
Mngt3_2YES
Pain
Mngt3_3YES
Pain
Mngt3_4YES
Pain
Mngt3_5YES
Pain
Mngt3_8YES
Pain
Mngt4_1YES
Pain
Mngt4_2YES
Pain
Mngt4_3YES
Pain
Mngt4_4YES
Pain
Mngt4_5YES
Pain
Mngt4_6YES
Pain
Mngt4_7YES
Pain
Mngt4_8YES
Pain
Mngt5_1YES
Pain
Mngt5_2YES
Pain
Mngt5_3YES
Pain
Mngt5_4YES
Pain
Mngt5_5YES
Pain
Mngt5_6YES
Pain
Mngt5_7YES
Pain
Mngt5_9YES
Pain
Mngt6_1YES
Pain
Mngt6_2YES
Pain
Mngt6_3YES
Pain
Mngt6_4YES
Pain
Mngt6_5YES
Pain
Mngt6_6YES
Pain
Mngt6_7YES
Pain
Mngt6_8YES
Pain
Mngt6_9YES
Pain
Mngt8_4YES
Pain
Mngt8_7YES
Pain
Mngt9_4YES
Pain
Mngt9_5YES
Pain
Mngt9_6YES
Pain
Mngt9_8YES
Pain
Mngt10_1YES
Pain
Mngt10_2YES
Pain
Mngt10_3YES
Pain
Mngt10_4YES
Pain
Mngt10_5YES
Pain
Mngt10_6YES
Pain
Mngt10_7YES
Pain
Mngt10_8YES
Pain
Mngt11_1YES
Pain
Mngt11_2YES
Pain
Mngt11_3YES
Pain
Mngt11_4YES
Pain
Mngt11_5YES
Pain
Mngt11_6YES
Pain
Mngt11_8YES
Pain
Mngt12_1YES
Pain
Mngt12_2YES
Pain
Mngt13_1YES
Pain
Mngt13_2YES
Pain
Mngt13_3YES
Pain
Mngt13_4YES
Pain
Mngt13_5YES
Pain
Mngt13_6YES
Pain
Mngt13_7YES
Pain
Mngt13_8YES
Pain
Mngt13_9YES
Pain
Mngt14_1YES
Pain
Mngt14_2YES
Pain
Mngt14_3YES
Pain
Mngt14_4YES
Pain
Mngt14_5YES
Pain
Mngt14_6YES
Pain
Mngt14_7YES
Pain
Mngt14_8YES
Pain
Mngt14_9YES
Pain
Mngt2_13YES
Pain
Mngt4_11YES
Pain
Mngt4_12YES
Pain
Mngt4_13YES
Pain
Mngt4_14YES
Pain
Mngt4_16YES
Pain
Mngt4_18YES
Physicial
Medicine1_1YES
Physicial
Medicine1_2YES
Physicial
Medicine1_3YES
Physicial
Medicine1_4YES
Physicial
Medicine1_5YES
Physicial
Medicine1_6YES
Physicial
Medicine1_7YES
Physicial
Medicine1_8YES
Physicial
Medicine2_1YES
Physicial
Medicine2_2YES
Physicial
Medicine2_3YES
Physicial
Medicine2_4YES
Physicial
Medicine2_5YES
Physicial
Medicine2_6YES
Physicial
Medicine2_7YES
Physicial
Medicine2_8YES
Physicial
Medicine2_9YES
Physicial
Medicine3_1YES
Physicial
Medicine3_2YES
Physicial
Medicine3_3YES
Physicial
Medicine3_4YES
Physicial
Medicine3_5YES
Physicial
Medicine3_8YES
Physicial
Medicine4_1YES
Physicial
Medicine4_2YES
Physicial
Medicine4_3YES
Physicial
Medicine4_4YES
Physicial
Medicine4_5YES
Physicial
Medicine4_6YES
Physicial
Medicine4_7YES
Physicial
Medicine4_8YES
Physicial
Medicine5_1YES
Physicial
Medicine5_2YES
Physicial
Medicine5_3YES
Physicial
Medicine5_4YES
Physicial
Medicine5_5YES
Physicial
Medicine5_6YES
Physicial
Medicine5_7YES
Physicial
Medicine5_9YES
Physicial
Medicine6_1YES
Physicial
Medicine6_2YES
Physicial
Medicine6_3YES
Physicial
Medicine6_4YES
Physicial
Medicine6_5YES
Physicial
Medicine6_6YES
Physicial
Medicine6_7YES
Physicial
Medicine6_8YES
Physicial
Medicine6_9YES
Physicial
Medicine8_4YES
Physicial
Medicine8_7YES
Physicial
Medicine9_1YES
Physicial
Medicine9_2YES
Physicial
Medicine9_4YES
Physicial
Medicine9_5YES
Physicial
Medicine9_6YES
Physicial
Medicine9_7YES
Physicial
Medicine9_8YES
Physicial
Medicine10_1YES
Physicial
Medicine10_2YES
Physicial
Medicine10_3YES
Physicial
Medicine10_4YES
Physicial
Medicine10_5YES
Physicial
Medicine10_6YES
Physicial
Medicine10_7YES
Physicial
Medicine10_8YES
Physicial
Medicine11_1YES
Physicial
Medicine11_2YES
Physicial
Medicine11_3YES
Physicial
Medicine11_4YES
Physicial
Medicine11_5YES
Physicial
Medicine11_6YES
Physicial
Medicine11_8YES
Physicial
Medicine12_1YES
Physicial
Medicine12_2YES
Physicial
Medicine12_3YES
Physicial
Medicine12_4YES
Physicial
Medicine12_5YES
Physicial
Medicine12_6YES
Physicial
Medicine12_7YES
Physicial
Medicine12_8YES
Physicial
Medicine12_9YES
Physicial
Medicine13_1YES
Physicial
Medicine13_2YES
Physicial
Medicine13_3YES
Physicial
Medicine13_4YES
Physicial
Medicine13_5YES
Physicial
Medicine13_6YES
Physicial
Medicine13_7YES
Physicial
Medicine13_8YES
Physicial
Medicine13_9YES
Physicial
Medicine14_1YES
Physicial
Medicine14_2YES
Physicial
Medicine14_3YES
Physicial
Medicine14_4YES
Physicial
Medicine14_5YES
Physicial
Medicine14_6YES
Physicial
Medicine14_7YES
Physicial
Medicine14_8YES
Physicial
Medicine14_9YES
Physicial
Medicine2_13YES
Physicial
Medicine4_11YES
Physicial
Medicine4_12YES
Physicial
Medicine4_13YES
Physicial
Medicine4_14YES
Physicial
Medicine4_16YES
Physicial
Medicine4_18YES
Physicial
Medicine12_11YES
Physicial
Medicine12_12YES
Podiatry1_1YES
Podiatry1_2YES
Podiatry1_3YES
Podiatry1_4YES
Podiatry1_5YES
Podiatry1_6YES
Podiatry1_7YES
Podiatry1_8YES
Podiatry2_1YES
Podiatry2_2YES
Podiatry2_3YES
Podiatry2_4YES
Podiatry2_5YES
Podiatry2_6YES
Podiatry2_7YES
Podiatry2_8YES
Podiatry2_9YES
Podiatry3_1YES
Podiatry3_2YES
Podiatry3_3YES
Podiatry3_4YES
Podiatry3_5YES
Podiatry3_8YES
Podiatry4_1YES
Podiatry4_3YES
Podiatry4_4YES
Podiatry4_5YES
Podiatry4_6YES
Podiatry4_7YES
Podiatry4_8YES
Podiatry4_9YES
Podiatry5_1YES
Podiatry5_3YES
Podiatry5_4YES
Podiatry5_5YES
Podiatry5_6YES
Podiatry5_7YES
Podiatry5_9YES
Podiatry6_1YES
Podiatry6_2YES
Podiatry6_3YES
Podiatry6_4YES
Podiatry6_5YES
Podiatry6_6YES
Podiatry6_7YES
Podiatry6_8YES
Podiatry6_9YES
Podiatry8_4YES
Podiatry8_7YES
Podiatry9_1YES
Podiatry9_2YES
Podiatry9_4YES
Podiatry9_5YES
Podiatry9_6YES
Podiatry9_7YES
Podiatry9_8YES
Podiatry10_1YES
Podiatry10_2YES
Podiatry10_3YES
Podiatry10_4YES
Podiatry10_5YES
Podiatry10_6YES
Podiatry10_7YES
Podiatry10_8YES
Podiatry11_1YES
Podiatry11_2YES
Podiatry11_3YES
Podiatry11_4YES
Podiatry11_5YES
Podiatry11_6YES
Podiatry11_8YES
Podiatry12_1YES
Podiatry12_2YES
Podiatry12_3YES
Podiatry12_4YES
Podiatry12_5YES
Podiatry12_6YES
Podiatry12_7YES
Podiatry12_8YES
Podiatry12_9YES
Podiatry13_1YES
Podiatry13_2YES
Podiatry13_3YES
Podiatry13_4YES
Podiatry13_5YES
Podiatry13_6YES
Podiatry13_7YES
Podiatry13_8YES
Podiatry13_9YES
Podiatry14_1YES
Podiatry14_2YES
Podiatry14_3YES
Podiatry14_4YES
Podiatry14_5YES
Podiatry14_6YES
Podiatry14_7YES
Podiatry14_8YES
Podiatry14_9YES
Podiatry2_13YES
Podiatry2_14YES
Podiatry4_11YES
Podiatry4_12YES
Podiatry4_13YES
Podiatry4_14YES
Podiatry4_15YES
Podiatry4_16YES
Podiatry12_11YES
Podiatry12_12YES
Psychiatry1_1YES
Psychiatry1_2YES
Psychiatry1_3YES
Psychiatry1_4YES
Psychiatry1_5YES
Psychiatry1_6YES
Psychiatry1_7YES
Psychiatry1_8YES
Psychiatry2_1YES
Psychiatry2_2YES
Psychiatry2_3YES
Psychiatry2_4YES
Psychiatry2_5YES
Psychiatry2_8YES
Psychiatry2_9YES
Psychiatry3_1YES
Psychiatry3_2YES
Psychiatry3_3YES
Psychiatry3_4YES
Psychiatry3_5YES
Psychiatry4_1YES
Psychiatry4_3YES
Psychiatry4_4YES
Psychiatry4_5YES
Psychiatry4_6YES
Psychiatry4_7YES
Psychiatry4_8YES
Psychiatry5_1YES
Psychiatry5_2YES
Psychiatry5_3YES
Psychiatry5_4YES
Psychiatry5_5YES
Psychiatry5_6YES
Psychiatry5_7YES
Psychiatry5_9YES
Psychiatry6_1YES
Psychiatry6_2YES
Psychiatry6_3YES
Psychiatry6_4YES
Psychiatry6_5YES
Psychiatry6_6YES
Psychiatry6_7YES
Psychiatry6_8YES
Psychiatry6_9YES
Psychiatry8_4YES
Psychiatry8_7YES
Psychiatry9_4YES
Psychiatry9_5YES
Psychiatry9_6YES
Psychiatry9_8YES
Psychiatry10_1YES
Psychiatry10_2YES
Psychiatry10_3YES
Psychiatry10_4YES
Psychiatry10_5YES
Psychiatry10_6YES
Psychiatry10_7YES
Psychiatry10_8YES
Psychiatry11_1YES
Psychiatry11_2YES
Psychiatry11_3YES
Psychiatry11_4YES
Psychiatry11_5YES
Psychiatry11_6YES
Psychiatry11_8YES
Psychiatry12_1YES
Psychiatry12_2YES
Psychiatry13_1YES
Psychiatry13_4YES
Psychiatry13_5YES
Psychiatry13_6YES
Psychiatry13_7YES
Psychiatry13_8YES
Psychiatry13_9YES
Psychiatry14_1YES
Psychiatry14_2YES
Psychiatry14_3YES
Psychiatry14_5YES
Psychiatry14_6YES
Psychiatry14_7YES
Psychiatry14_8YES
Psychiatry14_9YES
Psychiatry2_13YES
Psychiatry4_11YES
Psychiatry4_12YES
Psychiatry4_13YES
Psychiatry4_14YES
Psychiatry4_16YES
Psychiatry4_18YES
Psychology1_1YES
Psychology1_2YES
Psychology1_3YES
Psychology1_4YES
Psychology1_5YES
Psychology1_6YES
Psychology1_7YES
Psychology1_8YES
Psychology2_1YES
Psychology2_2YES
Psychology2_3YES
Psychology2_4YES
Psychology2_5YES
Psychology2_8YES
Psychology2_9YES
Psychology3_1YES
Psychology3_2YES
Psychology3_3YES
Psychology3_4YES
Psychology3_5YES
Psychology4_1YES
Psychology4_3YES
Psychology4_4YES
Psychology4_5YES
Psychology4_6YES
Psychology4_7YES
Psychology4_8YES
Psychology4_9YES
Psychology5_1YES
Psychology5_3YES
Psychology5_4YES
Psychology5_5YES
Psychology5_6YES
Psychology5_7YES
Psychology5_9YES
Psychology6_1YES
Psychology6_2YES
Psychology6_3YES
Psychology6_4YES
Psychology6_5YES
Psychology6_6YES
Psychology6_7YES
Psychology6_8YES
Psychology6_9YES
Psychology8_4YES
Psychology8_7YES
Psychology9_4YES
Psychology9_5YES
Psychology9_6YES
Psychology9_8YES
Psychology10_1YES
Psychology10_2YES
Psychology10_3YES
Psychology10_4YES
Psychology10_5YES
Psychology10_6YES
Psychology10_7YES
Psychology10_8YES
Psychology12_1YES
Psychology12_2YES
Psychology13_1YES
Psychology13_4YES
Psychology13_5YES
Psychology13_6YES
Psychology13_7YES
Psychology13_8YES
Psychology13_9YES
Psychology14_1YES
Psychology14_2YES
Psychology14_3YES
Psychology14_5YES
Psychology14_6YES
Psychology14_7YES
Psychology14_8YES
Psychology14_9YES
Psychology2_13YES
Psychology4_11YES
Psychology4_12YES
Psychology4_13YES
Psychology4_14YES
Psychology4_15YES
Psychology4_16YES
Psychology4_18YES
Pulmonology1_1YES
Pulmonology1_2YES
Pulmonology1_3YES
Pulmonology1_4YES
Pulmonology1_5YES
Pulmonology1_6YES
Pulmonology1_7YES
Pulmonology1_8YES
Pulmonology2_1YES
Pulmonology2_2YES
Pulmonology2_3YES
Pulmonology2_4YES
Pulmonology2_5YES
Pulmonology2_6YES
Pulmonology2_7YES
Pulmonology2_8YES
Pulmonology2_9YES
Pulmonology3_1YES
Pulmonology3_2YES
Pulmonology3_3YES
Pulmonology3_4YES
Pulmonology3_5YES
Pulmonology3_8YES
Pulmonology4_1YES
Pulmonology4_2YES
Pulmonology4_3YES
Pulmonology4_4YES
Pulmonology4_5YES
Pulmonology4_6YES
Pulmonology4_7YES
Pulmonology4_8YES
Pulmonology4_9YES
Pulmonology5_1YES
Pulmonology5_2YES
Pulmonology5_3YES
Pulmonology5_4YES
Pulmonology5_5YES
Pulmonology5_6YES
Pulmonology5_7YES
Pulmonology5_9YES
Pulmonology6_1YES
Pulmonology6_2YES
Pulmonology6_3YES
Pulmonology6_4YES
Pulmonology6_5YES
Pulmonology6_6YES
Pulmonology6_7YES
Pulmonology6_8YES
Pulmonology6_9YES
Pulmonology8_4YES
Pulmonology8_7YES
Pulmonology9_1YES
Pulmonology9_2YES
Pulmonology9_4YES
Pulmonology9_5YES
Pulmonology9_6YES
Pulmonology9_7YES
Pulmonology9_8YES
Pulmonology10_1YES
Pulmonology10_2YES
Pulmonology10_3YES
Pulmonology10_4YES
Pulmonology10_5YES
Pulmonology10_6YES
Pulmonology10_7YES
Pulmonology10_8YES
Pulmonology11_1YES
Pulmonology11_2YES
Pulmonology11_3YES
Pulmonology11_4YES
Pulmonology11_5YES
Pulmonology11_6YES
Pulmonology11_8YES
Pulmonology12_1YES
Pulmonology12_2YES
Pulmonology12_3YES
Pulmonology12_4YES
Pulmonology12_5YES
Pulmonology12_6YES
Pulmonology12_7YES
Pulmonology12_8YES
Pulmonology12_9YES
Pulmonology13_1YES
Pulmonology13_2YES
Pulmonology13_3YES
Pulmonology13_4YES
Pulmonology13_5YES
Pulmonology13_6YES
Pulmonology13_7YES
Pulmonology13_8YES
Pulmonology13_9YES
Pulmonology14_1YES
Pulmonology14_2YES
Pulmonology14_3YES
Pulmonology14_4YES
Pulmonology14_5YES
Pulmonology14_6YES
Pulmonology14_7YES
Pulmonology14_8YES
Pulmonology14_9YES
Pulmonology2_13YES
Pulmonology4_11YES
Pulmonology4_12YES
Pulmonology4_13YES
Pulmonology4_14YES
Pulmonology4_15YES
Pulmonology4_16YES
Pulmonology4_18YES
Pulmonology12_11YES
Pulmonology12_12YES
Rheumatology1_1YES
Rheumatology1_2YES
Rheumatology1_3YES
Rheumatology1_4YES
Rheumatology1_5YES
Rheumatology1_6YES
Rheumatology1_7YES
Rheumatology1_8YES
Rheumatology2_1YES
Rheumatology2_2YES
Rheumatology2_3YES
Rheumatology2_4YES
Rheumatology2_5YES
Rheumatology2_6YES
Rheumatology2_7YES
Rheumatology2_8YES
Rheumatology2_9YES
Rheumatology3_1YES
Rheumatology3_2YES
Rheumatology3_3YES
Rheumatology3_4YES
Rheumatology3_5YES
Rheumatology3_8YES
Rheumatology4_1YES
Rheumatology4_2YES
Rheumatology4_3YES
Rheumatology4_4YES
Rheumatology4_5YES
Rheumatology4_6YES
Rheumatology4_7YES
Rheumatology4_8YES
Rheumatology4_9YES
Rheumatology5_1YES
Rheumatology5_2YES
Rheumatology5_3YES
Rheumatology5_4YES
Rheumatology5_5YES
Rheumatology5_6YES
Rheumatology5_7YES
Rheumatology5_9YES
Rheumatology6_1YES
Rheumatology6_2YES
Rheumatology6_3YES
Rheumatology6_4YES
Rheumatology6_5YES
Rheumatology6_6YES
Rheumatology6_7YES
Rheumatology6_8YES
Rheumatology6_9YES
Rheumatology8_4YES
Rheumatology8_7YES
Rheumatology9_1YES
Rheumatology9_4YES
Rheumatology9_5YES
Rheumatology9_6YES
Rheumatology9_7YES
Rheumatology9_8YES
Rheumatology10_1YES
Rheumatology10_2YES
Rheumatology10_3YES
Rheumatology10_4YES
Rheumatology10_5YES
Rheumatology10_6YES
Rheumatology10_7YES
Rheumatology10_8YES
Rheumatology11_1YES
Rheumatology11_2YES
Rheumatology11_3YES
Rheumatology11_4YES
Rheumatology11_5YES
Rheumatology11_6YES
Rheumatology11_8YES
Rheumatology12_1YES
Rheumatology12_2YES
Rheumatology12_3YES
Rheumatology12_4YES
Rheumatology12_5YES
Rheumatology12_6YES
Rheumatology12_7YES
Rheumatology12_8YES
Rheumatology12_9YES
Rheumatology13_1YES
Rheumatology13_2YES
Rheumatology13_3YES
Rheumatology13_4YES
Rheumatology13_5YES
Rheumatology13_6YES
Rheumatology13_7YES
Rheumatology13_8YES
Rheumatology13_9YES
Rheumatology14_1YES
Rheumatology14_2YES
Rheumatology14_3YES
Rheumatology14_4YES
Rheumatology14_5YES
Rheumatology14_6YES
Rheumatology14_7YES
Rheumatology14_8YES
Rheumatology14_9YES
Rheumatology2_13YES
Rheumatology4_11YES
Rheumatology4_12YES
Rheumatology4_13YES
Rheumatology4_14YES
Rheumatology4_15YES
Rheumatology4_16YES
Rheumatology4_18YES
Rheumatology12_11YES
Rheumatology12_12YES
Sports
Medicine1_1YES
Sports
Medicine1_2YES
Sports
Medicine1_3YES
Sports
Medicine1_4YES
Sports
Medicine1_5YES
Sports
Medicine1_6YES
Sports
Medicine1_7YES
Sports
Medicine1_8YES
Sports
Medicine2_1YES
Sports
Medicine2_2YES
Sports
Medicine2_3YES
Sports
Medicine2_4YES
Sports
Medicine2_5YES
Sports
Medicine2_6YES
Sports
Medicine2_7YES
Sports
Medicine2_8YES
Sports
Medicine2_9YES
Sports
Medicine3_1YES
Sports
Medicine3_2YES
Sports
Medicine3_3YES
Sports
Medicine3_4YES
Sports
Medicine3_5YES
Sports
Medicine3_8YES
Sports
Medicine4_1YES
Sports
Medicine4_2YES
Sports
Medicine4_3YES
Sports
Medicine4_4YES
Sports
Medicine4_5YES
Sports
Medicine4_6YES
Sports
Medicine4_7YES
Sports
Medicine4_8YES
Sports
Medicine5_1YES
Sports
Medicine5_2YES
Sports
Medicine5_3YES
Sports
Medicine5_4YES
Sports
Medicine5_5YES
Sports
Medicine5_6YES
Sports
Medicine5_7YES
Sports
Medicine5_9YES
Sports
Medicine6_1YES
Sports
Medicine6_2YES
Sports
Medicine6_3YES
Sports
Medicine6_4YES
Sports
Medicine6_5YES
Sports
Medicine6_6YES
Sports
Medicine6_7YES
Sports
Medicine6_8YES
Sports
Medicine6_9YES
Sports
Medicine8_4YES
Sports
Medicine8_7YES
Sports
Medicine9_1YES
Sports
Medicine9_2YES
Sports
Medicine9_4YES
Sports
Medicine9_5YES
Sports
Medicine9_6YES
Sports
Medicine9_7YES
Sports
Medicine9_8YES
Sports
Medicine10_1YES
Sports
Medicine10_2YES
Sports
Medicine10_3YES
Sports
Medicine10_4YES
Sports
Medicine10_5YES
Sports
Medicine10_6YES
Sports
Medicine10_7YES
Sports
Medicine10_8YES
Sports
Medicine11_1YES
Sports
Medicine11_2YES
Sports
Medicine11_3YES
Sports
Medicine11_4YES
Sports
Medicine11_5YES
Sports
Medicine11_6YES
Sports
Medicine11_8YES
Sports
Medicine12_1YES
Sports
Medicine12_2YES
Sports
Medicine12_3YES
Sports
Medicine12_4YES
Sports
Medicine12_5YES
Sports
Medicine12_6YES
Sports
Medicine12_7YES
Sports
Medicine12_8YES
Sports
Medicine12_9YES
Sports
Medicine13_1YES
Sports
Medicine13_2YES
Sports
Medicine13_3YES
Sports
Medicine13_4YES
Sports
Medicine13_5YES
Sports
Medicine13_6YES
Sports
Medicine13_7YES
Sports
Medicine13_8YES
Sports
Medicine13_9YES
Sports
Medicine14_1YES
Sports
Medicine14_2YES
Sports
Medicine14_3YES
Sports
Medicine14_4YES
Sports
Medicine14_5YES
Sports
Medicine14_6YES
Sports
Medicine14_7YES
Sports
Medicine14_8YES
Sports
Medicine14_9YES
Sports
Medicine2_13YES
Sports
Medicine4_11YES
Sports
Medicine4_12YES
Sports
Medicine4_13YES
Sports
Medicine4_14YES
Sports
Medicine4_16YES
Sports
Medicine4_18YES
Sports
Medicine12_11YES
Sports
Medicine12_12YES
Urology1_1YES
Urology1_2YES
Urology1_3YES
Urology1_4YES
Urology1_5YES
Urology1_6YES
Urology1_7YES
Urology1_8YES
Urology2_1YES
Urology2_2YES
Urology2_3YES
Urology2_4YES
Urology2_5YES
Urology2_6YES
Urology2_7YES
Urology2_8YES
Urology2_9YES
Urology3_1YES
Urology3_2YES
Urology3_3YES
Urology3_4YES
Urology3_5YES
Urology3_8YES
Urology4_1YES
Urology4_2YES
Urology4_3YES
Urology4_4YES
Urology4_5YES
Urology4_6YES
Urology4_7YES
Urology4_8YES
Urology4_9YES
Urology5_1YES
Urology5_2YES
Urology5_3YES
Urology5_4YES
Urology5_5YES
Urology5_6YES
Urology5_7YES
Urology5_9YES
Urology6_1YES
Urology6_2YES
Urology6_3YES
Urology6_4YES
Urology6_5YES
Urology6_6YES
Urology6_7YES
Urology6_8YES
Urology6_9YES
Urology8_4YES
Urology8_7YES
Urology9_1YES
Urology9_4YES
Urology9_5YES
Urology9_6YES
Urology9_7YES
Urology9_8YES
Urology10_1YES
Urology10_2YES
Urology10_3YES
Urology10_4YES
Urology10_5YES
Urology10_6YES
Urology10_7YES
Urology10_8YES
Urology11_1YES
Urology11_2YES
Urology11_3YES
Urology11_4YES
Urology11_5YES
Urology11_6YES
Urology11_8YES
Urology12_1YES
Urology12_2YES
Urology12_3YES
Urology12_4YES
Urology12_5YES
Urology12_6YES
Urology12_7YES
Urology12_8YES
Urology12_9YES
Urology13_1YES
Urology13_2YES
Urology13_3YES
Urology13_4YES
Urology13_5YES
Urology13_6YES
Urology13_7YES
Urology13_8YES
Urology13_9YES
Urology14_1YES
Urology14_2YES
Urology14_3YES
Urology14_4YES
Urology14_5YES
Urology14_6YES
Urology14_7YES
Urology14_8YES
Urology14_9YES
Urology2_13YES
Urology4_11YES
Urology4_12YES
Urology4_13YES
Urology4_14YES
Urology4_15YES
Urology4_16YES
Urology4_18YES
Urology12_11 YES
Urology12_12 YES
Here's the query for the results above:
SELECT specialty,capnumber,capforthisspecialty
FROM CapYesForSpec
order by convert(int,dbo.ReplaceNonNumericChars(capNumber))
I actually wrote the code below to get the results I need but I have to adjust it for each specialty and its corresponding capforthisspecialty values. I cut out over a thousand lines because they repeat. Here's the gist:
use PracticeRefinement
go
if object_id('tempdb..#temp1') is not null
drop table #temp1
select distinct specialty, capnumber, convert(int,dbo.ReplaceNonNumericChars(capnumber)) as 'a',capforthisspecialty
,POPracticeUnitCode, POPracticeUnitDescription, specialtyredux
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8]),([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_10]),([2_11]),([2_12]),([2_13]),([2_14]),([2_15]),([2_16]),([2_17]),([2_18]),([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_6]),([3_7]),([3_8]),([3_9]),([3_10]),([3_11]),([3_12]),([3_13]),([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_10]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_17]),([4_18]),([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_8]),([5_9]),([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9]),([8_4]),([8_7]),([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8]),([9_9]),([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8]),([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_7]),([11_8]),([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_10]),([12_11]),([12_12]),([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9]),([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9]),([14_10])
into #temp1
from CapYesForSpec cy
inner join winter_2014uto wuto
on cy.specialty = wuto.specialtyredux
where specialty = 'Cardiology'
--and ([1_1] = 'YES' or [1_1] <> 'YES')
and capforthisspecialty = 'YES'
and capnumber = '1_1'
select * from #temp1
-- order by specialty,capnumber
union all
------------------{....removed > 1400 lines from here...}
select distinct specialty, capnumber, convert(int,dbo.ReplaceNonNumericChars(capnumber))as 'a',capforthisspecialty
,POPracticeUnitCode, POPracticeUnitDescription, specialtyredux
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8]),([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_10]),([2_11]),([2_12]),([2_13]),([2_14]),([2_15]),([2_16]),([2_17]),([2_18]),([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_6]),([3_7]),([3_8]),([3_9]),([3_10]),([3_11]),([3_12]),([3_13]),([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_10]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_17]),([4_18]),([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_8]),([5_9]),([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9]),([8_4]),([8_7]),([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8]),([9_9]),([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8]),([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_7]),([11_8]),([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_10]),([12_11]),([12_12]),([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9]),([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9]),([14_10])
from CapYesForSpec cy
inner join winter_2014uto wuto
on cy.specialty = wuto.specialtyredux
where specialty = 'Cardiology' and [1_1] = 'YES'
and capforthisspecialty = 'YES'
and capnumber = '14_8'
union all
select distinct specialty, capnumber, convert(int,dbo.ReplaceNonNumericChars(capnumber))as 'a',capforthisspecialty
,POPracticeUnitCode, POPracticeUnitDescription, specialtyredux
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8]),([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_10]),([2_11]),([2_12]),([2_13]),([2_14]),([2_15]),([2_16]),([2_17]),([2_18]),([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_6]),([3_7]),([3_8]),([3_9]),([3_10]),([3_11]),([3_12]),([3_13]),([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_10]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_17]),([4_18]),([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_8]),([5_9]),([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9]),([8_4]),([8_7]),([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8]),([9_9]),([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8]),([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_7]),([11_8]),([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_10]),([12_11]),([12_12]),([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9]),([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9]),([14_10])
from CapYesForSpec cy
inner join winter_2014uto wuto
on cy.specialty = wuto.specialtyredux
where specialty = 'Cardiology' and [1_1] = 'YES'
and capforthisspecialty = 'YES'
and capnumber = '14_9'
-- order by specialty,convert(int,dbo.ReplaceNonNumericChars(capnumber))
---*******************************
--select * from capyesforspec
--where specialty = 'Cardiology'
--order by specialty,convert(int,dbo.ReplaceNonNumericChars(capnumber))
select * from #temp1
select count(*) from #Temp1
select specialty
--, count(a)
-- , capnumber, a,capforthisspecialty
,POPracticeUnitCode
, POPracticeUnitDescription
--, specialtyredux
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8])
,([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_11]),([2_12]),([2_13]),([2_14])
,([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_8]),([3_11]),([3_12])
,([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_18])
,([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_9])
,([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9])
,([8_4]),([8_7])
,([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8])
,([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8])
,([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_8])
,([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_11]),([12_12])
,([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9])
,([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9])
from #Temp1
group by Specialty,POPracticeUnitDescription,POPracticeUnitCode
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8])
,([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_11]),([2_12]),([2_13]),([2_14])
,([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_8]),([3_11]),([3_12])
,([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_18])
,([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_9])
,([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9])
,([8_4]),([8_7])
,([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8])
,([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8])
,([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_8])
,([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_11]),([12_12]),([2_13]),([2_14])
,([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9])
,([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9])
order by specialty, POPracticeUnitDescription
--,a
if object_id('tempdb..#temp2') is not null
drop table #temp2
select specialty
,POPracticeUnitCode
, POPracticeUnitDescription
,([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8])
,([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_11]),([2_12]),([2_13]),([2_14])
,([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_8]),([3_11]),([3_12])
,([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_18])
,([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_9])
,([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9])
,([8_4]),([8_7])
,([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8])
,([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8])
,([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_8])
,([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_11]),([12_12])
,([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9])
,([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9])
into #temp2
from #temp1
select * from #temp2
if object_id('tempdb..#tempCardiology') is not null
drop table #tempCardiology
SELECT *
into #tempCardiology
FROM
dbo.#temp2 T
CROSS APPLY (
SELECT Count(*)
FROM (VALUES ([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8]),([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),([2_9]),([2_11]),([2_12]),([2_13]),([2_14]),([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),([3_8]),([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),([4_9]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_18]) ,([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),([5_6]),([5_7]),([5_9]),([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9]),([8_4]),([8_7]),([9_1]),([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8]),([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),([10_8]),([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_8]),([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),([12_6]),([12_7]),([12_8]),([12_9]),([12_11]),([12_12]),([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),([13_8]),([13_9]),([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9])) C (Val)
WHERE Val = 'YES'
) A (Cnt)
order by POPracticeUnitDescription
select distinct *, POPracticeUnitDescription,round((convert(float,cnt)/convert(float,110))*100.00,1) as percentInPlace
from #tempCardiology
order by 3
-- select * from #tempCardiology
Still with me? Thanks. I know there are better ways. Any and all ideas appreciated!
Here's an example of the results I need (the inner columns are removed so I can just show the results I'm really after without the detail columns to distract):
specialtyPOPracticeUnitCodeCntpercentInPlace
CardiologyB000000024373632.7
CardiologyB000000024713531.8
CardiologyB000000003625550
CardiologyB000000025324036.4
CardiologyB000000003713531.8
CardiologyB000000003723935.5
CardiologyB000000004423632.7
CardiologyB000000025664238.2
CardiologyB000000206984238.2
CardiologyB000000005897669.1
CardiologyB000000273016861.8
CardiologyB000000008454641.8
CardiologyB000000034153834.5
CardiologyB000000034856760.9
CardiologyB000000014052320.9
CardiologyB000000029061715.5
CardiologyB000000273117467.3
CardiologyB000000036702320.9
CardiologyB000000023198779.1

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

-- Please use table aliases so folks can tell which columns are from which tables.

-- why do you have brackets around some of the columns? e.g. ([1_1]),([1_2]),...

-- Are all those UNIONs necessary? Surely you need only 2 queries UNIONed together, like this:

SELECT DISTINCT

specialty,

capnumber,

convert(int,dbo.ReplaceNonNumericChars(capnumber)) as 'a', -- Try CAST(REPLACE(capnumber,'-','') AS INT)

capforthisspecialty,

POPracticeUnitCode,

POPracticeUnitDescription,

specialtyredux,

([1_1]),([1_2]),([1_3]),([1_4]),([1_5]),([1_6]),([1_7]),([1_8]),([2_1]),([2_2]),([2_3]),([2_4]),([2_5]),([2_6]),([2_7]),([2_8]),

([2_9]),([2_10]),([2_11]),([2_12]),([2_13]),([2_14]),([2_15]),([2_16]),([2_17]),([2_18]),([3_1]),([3_2]),([3_3]),([3_4]),([3_5]),

([3_6]),([3_7]),([3_8]),([3_9]),([3_10]),([3_11]),([3_12]),([3_13]),([4_1]),([4_2]),([4_3]),([4_4]),([4_5]),([4_6]),([4_7]),([4_8]),

([4_9]),([4_10]),([4_11]),([4_12]),([4_13]),([4_14]),([4_15]),([4_16]),([4_17]),([4_18]),([5_1]),([5_2]),([5_3]),([5_4]),([5_5]),

([5_6]),([5_7]),([5_8]),([5_9]),([6_1]),([6_2]),([6_3]),([6_4]),([6_5]),([6_6]),([6_7]),([6_8]),([6_9]),([8_4]),([8_7]),([9_1]),

([9_2]),([9_3]),([9_4]),([9_5]),([9_6]),([9_7]),([9_8]),([9_9]),([10_1]),([10_2]),([10_3]),([10_4]),([10_5]),([10_6]),([10_7]),

([10_8]),([11_1]),([11_2]),([11_3]),([11_4]),([11_5]),([11_6]),([11_7]),([11_8]),([12_1]),([12_2]),([12_3]),([12_4]),([12_5]),

([12_6]),([12_7]),([12_8]),([12_9]),([12_10]),([12_11]),([12_12]),([13_1]),([13_2]),([13_3]),([13_4]),([13_5]),([13_6]),([13_7]),

([13_8]),([13_9]),([14_1]),([14_2]),([14_3]),([14_4]),([14_5]),([14_6]),([14_7]),([14_8]),([14_9]),([14_10])

--into #temp1

FROM CapYesForSpec c

INNER JOIN winter_2014uto w

ON c.specialty = w.specialtyredux

WHERE c.specialty = 'Cardiology'

--and ([1_1] = 'YES' or [1_1] <> 'YES')

AND capforthisspecialty = 'YES'

AND capnumber = '1_1'

UNION ALL

SELECT DISTINCT

specialty,

capnumber,

convert(int,dbo.ReplaceNonNumericChars(capnumber)) as 'a',