Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help with taking this script from primitive to dynamic Expand / Collapse
Author
Message
Posted Sunday, February 23, 2014 8:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 57, Visits: 375
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):
specialty	capnumber	capforthisspecialty
Allergy 1_1 YES
Allergy 1_2 YES
Allergy 1_3 YES
Allergy 1_4 YES
Allergy 1_5 YES
Allergy 1_6 YES
Allergy 1_7 YES
Allergy 1_8 YES
Allergy 2_1 YES
Allergy 2_2 YES
Allergy 2_3 YES
Allergy 2_4 YES
Allergy 2_5 YES
Allergy 2_6 YES
Allergy 2_7 YES
Allergy 2_8 YES
Allergy 2_9 YES
Allergy 3_1 YES
Allergy 3_2 YES
Allergy 3_3 YES
Allergy 3_4 YES
Allergy 3_5 YES
Allergy 3_8 YES
Allergy 4_1 YES
Allergy 4_2 YES
Allergy 4_3 YES
Allergy 4_4 YES
Allergy 4_5 YES
Allergy 4_6 YES
Allergy 4_7 YES
Allergy 4_8 YES
Allergy 4_9 YES
Allergy 5_1 YES
Allergy 5_2 YES
Allergy 5_3 YES
Allergy 5_4 YES
Allergy 5_5 YES
Allergy 5_6 YES
Allergy 5_7 YES
Allergy 5_9 YES
Allergy 6_1 YES
Allergy 6_2 YES
Allergy 6_3 YES
Allergy 6_4 YES
Allergy 6_5 YES
Allergy 6_6 YES
Allergy 6_7 YES
Allergy 6_8 YES
Allergy 6_9 YES
Allergy 8_4 YES
Allergy 8_7 YES
Allergy 9_1 YES
Allergy 9_2 YES
Allergy 9_3 YES
Allergy 9_4 YES
Allergy 9_5 YES
Allergy 9_6 YES
Allergy 9_8 YES
Allergy 10_1 YES
Allergy 10_2 YES
Allergy 10_3 YES
Allergy 10_4 YES
Allergy 10_5 YES
Allergy 10_6 YES
Allergy 10_7 YES
Allergy 10_8 YES
Allergy 11_1 YES
Allergy 11_2 YES
Allergy 11_3 YES
Allergy 11_4 YES
Allergy 11_5 YES
Allergy 11_6 YES
Allergy 11_8 YES
Allergy 12_1 YES
Allergy 12_2 YES
Allergy 12_3 YES
Allergy 12_4 YES
Allergy 12_5 YES
Allergy 12_6 YES
Allergy 12_7 YES
Allergy 12_8 YES
Allergy 12_9 YES
Allergy 13_1 YES
Allergy 13_2 YES
Allergy 13_3 YES
Allergy 13_4 YES
Allergy 13_5 YES
Allergy 13_6 YES
Allergy 13_7 YES
Allergy 13_8 YES
Allergy 13_9 YES
Allergy 14_1 YES
Allergy 14_2 YES
Allergy 14_3 YES
Allergy 14_4 YES
Allergy 14_5 YES
Allergy 14_6 YES
Allergy 14_7 YES
Allergy 14_8 YES
Allergy 14_9 YES
Allergy 2_13 YES
Allergy 2_14 YES
Allergy 4_11 YES
Allergy 4_12 YES
Allergy 4_13 YES
Allergy 4_14 YES
Allergy 4_15 YES
Allergy 4_16 YES
Allergy 12_11 YES
Allergy 12_12 YES
Cardiology 1_1 YES
Cardiology 1_2 YES
Cardiology 1_3 YES
Cardiology 1_4 YES
Cardiology 1_5 YES
Cardiology 1_6 YES
Cardiology 1_7 YES
Cardiology 1_8 YES
Cardiology 2_1 YES
Cardiology 2_2 YES
Cardiology 2_3 YES
Cardiology 2_4 YES
Cardiology 2_5 YES
Cardiology 2_6 YES
Cardiology 2_7 YES
Cardiology 2_8 YES
Cardiology 2_9 YES
Cardiology 3_1 YES
Cardiology 3_2 YES
Cardiology 3_3 YES
Cardiology 3_4 YES
Cardiology 3_5 YES
Cardiology 3_8 YES
Cardiology 4_1 YES
Cardiology 4_2 YES
Cardiology 4_3 YES
Cardiology 4_4 YES
Cardiology 4_5 YES
Cardiology 4_6 YES
Cardiology 4_7 YES
Cardiology 4_8 YES
Cardiology 4_9 YES
Cardiology 5_1 YES
Cardiology 5_2 YES
Cardiology 5_3 YES
Cardiology 5_4 YES
Cardiology 5_5 YES
Cardiology 5_6 YES
Cardiology 5_7 YES
Cardiology 5_9 YES
Cardiology 6_1 YES
Cardiology 6_2 YES
Cardiology 6_3 YES
Cardiology 6_4 YES
Cardiology 6_5 YES
Cardiology 6_6 YES
Cardiology 6_7 YES
Cardiology 6_8 YES
Cardiology 6_9 YES
Cardiology 8_4 YES
Cardiology 8_7 YES
Cardiology 9_1 YES
Cardiology 9_2 YES
Cardiology 9_3 YES
Cardiology 9_4 YES
Cardiology 9_5 YES
Cardiology 9_6 YES
Cardiology 9_7 YES
Cardiology 9_8 YES
Cardiology 10_1 YES
Cardiology 10_2 YES
Cardiology 10_3 YES
Cardiology 10_4 YES
Cardiology 10_5 YES
Cardiology 10_6 YES
Cardiology 10_7 YES
Cardiology 10_8 YES
Cardiology 11_1 YES
Cardiology 11_2 YES
Cardiology 11_3 YES
Cardiology 11_4 YES
Cardiology 11_5 YES
Cardiology 11_6 YES
Cardiology 11_8 YES
Cardiology 12_1 YES
Cardiology 12_2 YES
Cardiology 12_3 YES
Cardiology 12_4 YES
Cardiology 12_5 YES
Cardiology 12_6 YES
Cardiology 12_7 YES
Cardiology 12_8 YES
Cardiology 12_9 YES
Cardiology 13_1 YES
Cardiology 13_2 YES
Cardiology 13_3 YES
Cardiology 13_4 YES
Cardiology 13_5 YES
Cardiology 13_6 YES
Cardiology 13_7 YES
Cardiology 13_8 YES
Cardiology 13_9 YES
Cardiology 14_1 YES
Cardiology 14_2 YES
Cardiology 14_3 YES
Cardiology 14_4 YES
Cardiology 14_5 YES
Cardiology 14_6 YES
Cardiology 14_7 YES
Cardiology 14_8 YES
Cardiology 14_9 YES
Cardiology 2_11 YES
Cardiology 2_12 YES
Cardiology 2_13 YES
Cardiology 2_14 YES
Cardiology 3_11 YES
Cardiology 3_12 YES
Cardiology 4_11 YES
Cardiology 4_12 YES
Cardiology 4_13 YES
Cardiology 4_14 YES
Cardiology 4_15 YES
Cardiology 4_16 YES
Cardiology 4_18 YES
Cardiology 12_11 YES
Cardiology 12_12 YES
Critical Care 1_1 YES
Critical Care 2_1 YES
Critical Care 2_3 YES
Critical Care 2_5 YES
Critical Care 2_8 YES
Critical Care 2_9 YES
Critical Care 3_1 YES
Critical Care 3_3 YES
Critical Care 3_4 YES
Critical Care 3_5 YES
Critical Care 4_1 YES
Critical Care 4_3 YES
Critical Care 4_4 YES
Critical Care 4_7 YES
Critical Care 5_1 YES
Critical Care 5_3 YES
Critical Care 5_4 YES
Critical Care 5_5 YES
Critical Care 5_6 YES
Critical Care 5_9 YES
Critical Care 6_1 YES
Critical Care 6_2 YES
Critical Care 6_3 YES
Critical Care 6_4 YES
Critical Care 6_5 YES
Critical Care 6_6 YES
Critical Care 6_7 YES
Critical Care 6_8 YES
Critical Care 6_9 YES
Critical Care 8_4 YES
Critical Care 8_7 YES
Critical Care 9_5 YES
Critical Care 9_6 YES
Critical Care 9_8 YES
Critical Care 10_1 YES
Critical Care 10_2 YES
Critical Care 10_3 YES
Critical Care 10_4 YES
Critical Care 10_5 YES
Critical Care 10_6 YES
Critical Care 12_1 YES
Critical Care 12_2 YES
Critical Care 13_1 YES
Critical Care 13_2 YES
Critical Care 13_4 YES
Critical Care 13_5 YES
Critical Care 13_6 YES
Critical Care 13_7 YES
Critical Care 13_8 YES
Critical Care 13_9 YES
Critical Care 2_12 YES
Critical Care 2_13 YES
Critical Care 3_12 YES
Critical Care 4_16 YES
Critical Care 4_18 YES
Emergency
Medicine 1_1 YES
Emergency
Medicine 2_1 YES
Emergency
Medicine 2_3 YES
Emergency
Medicine 2_5 YES
Emergency
Medicine 2_8 YES
Emergency
Medicine 2_9 YES
Emergency
Medicine 3_1 YES
Emergency
Medicine 3_3 YES
Emergency
Medicine 3_4 YES
Emergency
Medicine 3_5 YES
Emergency
Medicine 4_1 YES
Emergency
Medicine 4_3 YES
Emergency
Medicine 4_4 YES
Emergency
Medicine 4_7 YES
Emergency
Medicine 5_1 YES
Emergency
Medicine 5_3 YES
Emergency
Medicine 5_4 YES
Emergency
Medicine 5_5 YES
Emergency
Medicine 5_6 YES
Emergency
Medicine 5_9 YES
Emergency
Medicine 6_1 YES
Emergency
Medicine 6_2 YES
Emergency
Medicine 6_3 YES
Emergency
Medicine 6_4 YES
Emergency
Medicine 6_5 YES
Emergency
Medicine 6_6 YES
Emergency
Medicine 6_7 YES
Emergency
Medicine 6_8 YES
Emergency
Medicine 6_9 YES
Emergency
Medicine 8_4 YES
Emergency
Medicine 8_7 YES
Emergency
Medicine 9_5 YES
Emergency
Medicine 9_6 YES
Emergency
Medicine 9_8 YES
Emergency
Medicine 10_1 YES
Emergency
Medicine 10_2 YES
Emergency
Medicine 10_3 YES
Emergency
Medicine 10_4 YES
Emergency
Medicine 10_5 YES
Emergency
Medicine 10_6 YES
Emergency
Medicine 12_1 YES
Emergency
Medicine 12_2 YES
Emergency
Medicine 13_1 YES
Emergency
Medicine 13_4 YES
Emergency
Medicine 13_5 YES
Emergency
Medicine 14_1 YES
Emergency
Medicine 14_9 YES
Emergency
Medicine 2_13 YES
Emergency
Medicine 4_16 YES
Endocrinology 1_1 YES
Endocrinology 1_2 YES
Endocrinology 1_3 YES
Endocrinology 1_5 YES
Endocrinology 1_6 YES
Endocrinology 1_7 YES
Endocrinology 1_8 YES
Endocrinology 2_1 YES
Endocrinology 2_2 YES
Endocrinology 2_3 YES
Endocrinology 2_4 YES
Endocrinology 2_5 YES
Endocrinology 2_6 YES
Endocrinology 2_7 YES
Endocrinology 2_8 YES
Endocrinology 2_9 YES
Endocrinology 3_1 YES
Endocrinology 3_2 YES
Endocrinology 3_3 YES
Endocrinology 3_4 YES
Endocrinology 3_5 YES
Endocrinology 3_6 YES
Endocrinology 3_8 YES
Endocrinology 4_1 YES
Endocrinology 4_2 YES
Endocrinology 4_3 YES
Endocrinology 4_4 YES
Endocrinology 4_5 YES
Endocrinology 4_6 YES
Endocrinology 4_7 YES
Endocrinology 4_8 YES
Endocrinology 4_9 YES
Endocrinology 5_1 YES
Endocrinology 5_2 YES
Endocrinology 5_3 YES
Endocrinology 5_4 YES
Endocrinology 5_5 YES
Endocrinology 5_6 YES
Endocrinology 5_7 YES
Endocrinology 5_9 YES
Endocrinology 6_1 YES
Endocrinology 6_2 YES
Endocrinology 6_3 YES
Endocrinology 6_4 YES
Endocrinology 6_5 YES
Endocrinology 6_6 YES
Endocrinology 6_7 YES
Endocrinology 6_8 YES
Endocrinology 6_9 YES
Endocrinology 8_4 YES
Endocrinology 8_7 YES
Endocrinology 9_1 YES
Endocrinology 9_2 YES
Endocrinology 9_3 YES
Endocrinology 9_4 YES
Endocrinology 9_5 YES
Endocrinology 9_6 YES
Endocrinology 9_7 YES
Endocrinology 9_8 YES
Endocrinology 10_1 YES
Endocrinology 10_2 YES
Endocrinology 10_3 YES
Endocrinology 10_4 YES
Endocrinology 10_5 YES
Endocrinology 10_6 YES
Endocrinology 10_7 YES
Endocrinology 10_8 YES
Endocrinology 11_1 YES
Endocrinology 11_2 YES
Endocrinology 11_3 YES
Endocrinology 11_4 YES
Endocrinology 11_5 YES
Endocrinology 11_6 YES
Endocrinology 11_8 YES
Endocrinology 12_1 YES
Endocrinology 12_2 YES
Endocrinology 12_3 YES
Endocrinology 12_4 YES
Endocrinology 12_5 YES
Endocrinology 12_6 YES
Endocrinology 12_7 YES
Endocrinology 12_8 YES
Endocrinology 12_9 YES
Endocrinology 13_1 YES
Endocrinology 13_2 YES
Endocrinology 13_3 YES
Endocrinology 13_4 YES
Endocrinology 13_5 YES
Endocrinology 13_6 YES
Endocrinology 13_7 YES
Endocrinology 13_8 YES
Endocrinology 13_9 YES
Endocrinology 14_1 YES
Endocrinology 14_2 YES
Endocrinology 14_3 YES
Endocrinology 14_4 YES
Endocrinology 14_5 YES
Endocrinology 14_6 YES
Endocrinology 14_7 YES
Endocrinology 14_8 YES
Endocrinology 14_9 YES
Endocrinology 2_13 YES
Endocrinology 2_14 YES
Endocrinology 2_17 YES
Endocrinology 4_11 YES
Endocrinology 4_12 YES
Endocrinology 4_13 YES
Endocrinology 4_14 YES
Endocrinology 4_15 YES
Endocrinology 4_16 YES
Endocrinology 4_18 YES
Endocrinology 12_11 YES
Gastroenterology 1_1 YES
Gastroenterology 1_2 YES
Gastroenterology 1_3 YES
Gastroenterology 1_4 YES
Gastroenterology 1_5 YES
Gastroenterology 1_6 YES
Gastroenterology 1_7 YES
Gastroenterology 1_8 YES
Gastroenterology 2_1 YES
Gastroenterology 2_2 YES
Gastroenterology 2_3 YES
Gastroenterology 2_4 YES
Gastroenterology 2_5 YES
Gastroenterology 2_6 YES
Gastroenterology 2_7 YES
Gastroenterology 2_8 YES
Gastroenterology 2_9 YES
Gastroenterology 3_1 YES
Gastroenterology 3_2 YES
Gastroenterology 3_3 YES
Gastroenterology 3_4 YES
Gastroenterology 3_5 YES
Gastroenterology 3_8 YES
Gastroenterology 4_1 YES
Gastroenterology 4_2 YES
Gastroenterology 4_3 YES
Gastroenterology 4_4 YES
Gastroenterology 4_5 YES
Gastroenterology 4_6 YES
Gastroenterology 4_7 YES
Gastroenterology 4_8 YES
Gastroenterology 4_9 YES
Gastroenterology 5_1 YES
Gastroenterology 5_2 YES
Gastroenterology 5_3 YES
Gastroenterology 5_4 YES
Gastroenterology 5_5 YES
Gastroenterology 5_6 YES
Gastroenterology 5_7 YES
Gastroenterology 5_9 YES
Gastroenterology 6_1 YES
Gastroenterology 6_2 YES
Gastroenterology 6_3 YES
Gastroenterology 6_4 YES
Gastroenterology 6_5 YES
Gastroenterology 6_6 YES
Gastroenterology 6_7 YES
Gastroenterology 6_8 YES
Gastroenterology 6_9 YES
Gastroenterology 8_4 YES
Gastroenterology 8_7 YES
Gastroenterology 9_1 YES
Gastroenterology 9_2 YES
Gastroenterology 9_4 YES
Gastroenterology 9_5 YES
Gastroenterology 9_6 YES
Gastroenterology 9_7 YES
Gastroenterology 9_8 YES
Gastroenterology 10_1 YES
Gastroenterology 10_2 YES
Gastroenterology 10_3 YES
Gastroenterology 10_4 YES
Gastroenterology 10_5 YES
Gastroenterology 10_6 YES
Gastroenterology 10_7 YES
Gastroenterology 10_8 YES
Gastroenterology 12_1 YES
Gastroenterology 12_2 YES
Gastroenterology 12_3 YES
Gastroenterology 12_4 YES
Gastroenterology 12_5 YES
Gastroenterology 12_6 YES
Gastroenterology 12_7 YES
Gastroenterology 12_8 YES
Gastroenterology 12_9 YES
Gastroenterology 13_1 YES
Gastroenterology 13_2 YES
Gastroenterology 13_3 YES
Gastroenterology 13_4 YES
Gastroenterology 13_5 YES
Gastroenterology 13_6 YES
Gastroenterology 13_7 YES
Gastroenterology 13_8 YES
Gastroenterology 13_9 YES
Gastroenterology 14_1 YES
Gastroenterology 14_2 YES
Gastroenterology 14_3 YES
Gastroenterology 14_4 YES
Gastroenterology 14_5 YES
Gastroenterology 14_6 YES
Gastroenterology 14_7 YES
Gastroenterology 14_8 YES
Gastroenterology 14_9 YES
Gastroenterology 2_11 YES
Gastroenterology 2_13 YES
Gastroenterology 2_14 YES
Gastroenterology 4_11 YES
Gastroenterology 4_12 YES
Gastroenterology 4_13 YES
Gastroenterology 4_14 YES
Gastroenterology 4_15 YES
Gastroenterology 4_16 YES
Gastroenterology 4_18 YES
Gastroenterology 12_11 YES
Gastroenterology 12_12 YES
Infectious
Disease 1_1 YES
Infectious
Disease 1_2 YES
Infectious
Disease 1_3 YES
Infectious
Disease 1_4 YES
Infectious
Disease 1_5 YES
Infectious
Disease 1_6 YES
Infectious
Disease 1_7 YES
Infectious
Disease 1_8 YES
Infectious
Disease 2_1 YES
Infectious
Disease 2_2 YES
Infectious
Disease 2_3 YES
Infectious
Disease 2_4 YES
Infectious
Disease 2_5 YES
Infectious
Disease 2_6 YES
Infectious
Disease 2_7 YES
Infectious
Disease 2_8 YES
Infectious
Disease 2_9 YES
Infectious
Disease 3_1 YES
Infectious
Disease 3_2 YES
Infectious
Disease 3_3 YES
Infectious
Disease 3_4 YES
Infectious
Disease 3_5 YES
Infectious
Disease 3_8 YES
Infectious
Disease 4_1 YES
Infectious
Disease 4_2 YES
Infectious
Disease 4_3 YES
Infectious
Disease 4_4 YES
Infectious
Disease 4_5 YES
Infectious
Disease 4_6 YES
Infectious
Disease 4_7 YES
Infectious
Disease 4_8 YES
Infectious
Disease 4_9 YES
Infectious
Disease 5_1 YES
Infectious
Disease 5_2 YES
Infectious
Disease 5_3 YES
Infectious
Disease 5_4 YES
Infectious
Disease 5_5 YES
Infectious
Disease 5_6 YES
Infectious
Disease 5_7 YES
Infectious
Disease 5_9 YES
Infectious
Disease 6_1 YES
Infectious
Disease 6_2 YES
Infectious
Disease 6_3 YES
Infectious
Disease 6_4 YES
Infectious
Disease 6_5 YES
Infectious
Disease 6_6 YES
Infectious
Disease 6_7 YES
Infectious
Disease 6_8 YES
Infectious
Disease 6_9 YES
Infectious
Disease 8_4 YES
Infectious
Disease 8_7 YES
Infectious
Disease 9_4 YES
Infectious
Disease 9_5 YES
Infectious
Disease 9_6 YES
Infectious
Disease 9_8 YES
Infectious
Disease 10_1 YES
Infectious
Disease 10_2 YES
Infectious
Disease 10_3 YES
Infectious
Disease 10_4 YES
Infectious
Disease 10_5 YES
Infectious
Disease 10_6 YES
Infectious
Disease 10_7 YES
Infectious
Disease 10_8 YES
Infectious
Disease 11_1 YES
Infectious
Disease 11_2 YES
Infectious
Disease 11_3 YES
Infectious
Disease 11_4 YES
Infectious
Disease 11_5 YES
Infectious
Disease 11_6 YES
Infectious
Disease 11_8 YES
Infectious
Disease 12_1 YES
Infectious
Disease 12_2 YES
Infectious
Disease 12_3 YES
Infectious
Disease 12_4 YES
Infectious
Disease 12_5 YES
Infectious
Disease 12_6 YES
Infectious
Disease 12_7 YES
Infectious
Disease 12_8 YES
Infectious
Disease 12_9 YES
Infectious
Disease 13_1 YES
Infectious
Disease 13_2 YES
Infectious
Disease 13_3 YES
Infectious
Disease 13_4 YES
Infectious
Disease 13_5 YES
Infectious
Disease 13_6 YES
Infectious
Disease 13_7 YES
Infectious
Disease 13_8 YES
Infectious
Disease 13_9 YES
Infectious
Disease 14_1 YES
Infectious
Disease 14_2 YES
Infectious
Disease 14_3 YES
Infectious
Disease 14_4 YES
Infectious
Disease 14_5 YES
Infectious
Disease 14_6 YES
Infectious
Disease 14_7 YES
Infectious
Disease 14_8 YES
Infectious
Disease 14_9 YES
Infectious
Disease 2_13 YES
Infectious
Disease 4_11 YES
Infectious
Disease 4_12 YES
Infectious
Disease 4_13 YES
Infectious
Disease 4_14 YES
Infectious
Disease 4_15 YES
Infectious
Disease 4_16 YES
Infectious
Disease 4_18 YES
Infectious
Disease 12_11 YES
Infectious
Disease 12_12 YES
Neonatal
Care 1_1 YES
Neonatal
Care 2_1 YES
Neonatal
Care 2_3 YES
Neonatal
Care 2_4 YES
Neonatal
Care 2_5 YES
Neonatal
Care 2_8 YES
Neonatal
Care 2_9 YES
Neonatal
Care 3_1 YES
Neonatal
Care 3_3 YES
Neonatal
Care 3_4 YES
Neonatal
Care 3_5 YES
Neonatal
Care 4_1 YES
Neonatal
Care 4_2 YES
Neonatal
Care 4_3 YES
Neonatal
Care 4_4 YES
Neonatal
Care 4_6 YES
Neonatal
Care 4_7 YES
Neonatal
Care 4_8 YES
Neonatal
Care 5_1 YES
Neonatal
Care 5_2 YES
Neonatal
Care 5_3 YES
Neonatal
Care 5_4 YES
Neonatal
Care 5_5 YES
Neonatal
Care 5_6 YES
Neonatal
Care 5_9 YES
Neonatal
Care 6_1 YES
Neonatal
Care 6_2 YES
Neonatal
Care 6_3 YES
Neonatal
Care 6_4 YES
Neonatal
Care 6_5 YES
Neonatal
Care 6_6 YES
Neonatal
Care 6_7 YES
Neonatal
Care 6_8 YES
Neonatal
Care 6_9 YES
Neonatal
Care 8_4 YES
Neonatal
Care 8_7 YES
Neonatal
Care 9_5 YES
Neonatal
Care 9_6 YES
Neonatal
Care 9_8 YES
Neonatal
Care 10_1 YES
Neonatal
Care 10_2 YES
Neonatal
Care 10_3 YES
Neonatal
Care 10_4 YES
Neonatal
Care 10_5 YES
Neonatal
Care 10_6 YES
Neonatal
Care 12_1 YES
Neonatal
Care 12_2 YES
Neonatal
Care 13_1 YES
Neonatal
Care 13_2 YES
Neonatal
Care 13_3 YES
Neonatal
Care 13_4 YES
Neonatal
Care 13_5 YES
Neonatal
Care 13_6 YES
Neonatal
Care 13_7 YES
Neonatal
Care 13_8 YES
Neonatal
Care 13_9 YES
Neonatal
Care 2_13 YES
Neonatal
Care 4_12 YES
Neonatal
Care 4_13 YES
Neonatal
Care 4_14 YES
Neonatal
Care 4_16 YES
Neonatal
Care 4_17 YES
Neonatal
Care 4_18 YES
Nephrology 1_1 YES
Nephrology 1_2 YES
Nephrology 1_3 YES
Nephrology 1_4 YES
Nephrology 1_5 YES
Nephrology 1_6 YES
Nephrology 1_7 YES
Nephrology 1_8 YES
Nephrology 2_1 YES
Nephrology 2_2 YES
Nephrology 2_3 YES
Nephrology 2_4 YES
Nephrology 2_5 YES
Nephrology 2_6 YES
Nephrology 2_7 YES
Nephrology 2_8 YES
Nephrology 2_9 YES
Nephrology 3_1 YES
Nephrology 3_2 YES
Nephrology 3_3 YES
Nephrology 3_4 YES
Nephrology 3_5 YES
Nephrology 3_8 YES
Nephrology 4_1 YES
Nephrology 4_2 YES
Nephrology 4_3 YES
Nephrology 4_4 YES
Nephrology 4_5 YES
Nephrology 4_6 YES
Nephrology 4_7 YES
Nephrology 4_8 YES
Nephrology 4_9 YES
Nephrology 5_1 YES
Nephrology 5_2 YES
Nephrology 5_3 YES
Nephrology 5_4 YES
Nephrology 5_5 YES
Nephrology 5_6 YES
Nephrology 5_7 YES
Nephrology 5_9 YES
Nephrology 6_1 YES
Nephrology 6_2 YES
Nephrology 6_3 YES
Nephrology 6_4 YES
Nephrology 6_5 YES
Nephrology 6_6 YES
Nephrology 6_7 YES
Nephrology 6_8 YES
Nephrology 6_9 YES
Nephrology 8_4 YES
Nephrology 8_7 YES
Nephrology 9_1 YES
Nephrology 9_2 YES
Nephrology 9_4 YES
Nephrology 9_5 YES
Nephrology 9_6 YES
Nephrology 9_7 YES
Nephrology 9_8 YES
Nephrology 10_1 YES
Nephrology 10_2 YES
Nephrology 10_3 YES
Nephrology 10_4 YES
Nephrology 10_5 YES
Nephrology 10_6 YES
Nephrology 10_7 YES
Nephrology 10_8 YES
Nephrology 11_1 YES
Nephrology 11_2 YES
Nephrology 11_3 YES
Nephrology 11_4 YES
Nephrology 11_5 YES
Nephrology 11_6 YES
Nephrology 11_8 YES
Nephrology 12_1 YES
Nephrology 12_2 YES
Nephrology 12_3 YES
Nephrology 12_4 YES
Nephrology 12_5 YES
Nephrology 12_6 YES
Nephrology 12_7 YES
Nephrology 12_8 YES
Nephrology 12_9 YES
Nephrology 13_1 YES
Nephrology 13_2 YES
Nephrology 13_3 YES
Nephrology 13_4 YES
Nephrology 13_5 YES
Nephrology 13_6 YES
Nephrology 13_7 YES
Nephrology 13_8 YES
Nephrology 13_9 YES
Nephrology 14_1 YES
Nephrology 14_2 YES
Nephrology 14_3 YES
Nephrology 14_4 YES
Nephrology 14_5 YES
Nephrology 14_6 YES
Nephrology 14_7 YES
Nephrology 14_8 YES
Nephrology 14_9 YES
Nephrology 2_13 YES
Nephrology 2_14 YES
Nephrology 2_16 YES
Nephrology 4_11 YES
Nephrology 4_12 YES
Nephrology 4_13 YES
Nephrology 4_14 YES
Nephrology 4_15 YES
Nephrology 4_16 YES
Nephrology 4_18 YES
Nephrology 12_11 YES
Nephrology 12_12 YES
Neurology 1_1 YES
Neurology 1_2 YES
Neurology 1_3 YES
Neurology 1_4 YES
Neurology 1_5 YES
Neurology 1_6 YES
Neurology 1_7 YES
Neurology 1_8 YES
Neurology 2_1 YES
Neurology 2_2 YES
Neurology 2_3 YES
Neurology 2_4 YES
Neurology 2_5 YES
Neurology 2_6 YES
Neurology 2_7 YES
Neurology 2_8 YES
Neurology 2_9 YES
Neurology 3_1 YES
Neurology 3_2 YES
Neurology 3_3 YES
Neurology 3_4 YES
Neurology 3_5 YES
Neurology 3_8 YES
Neurology 4_1 YES
Neurology 4_2 YES
Neurology 4_3 YES
Neurology 4_4 YES
Neurology 4_5 YES
Neurology 4_6 YES
Neurology 4_7 YES
Neurology 4_8 YES
Neurology 4_9 YES
Neurology 5_1 YES
Neurology 5_2 YES
Neurology 5_3 YES
Neurology 5_4 YES
Neurology 5_5 YES
Neurology 5_6 YES
Neurology 5_7 YES
Neurology 5_9 YES
Neurology 6_1 YES
Neurology 6_2 YES
Neurology 6_3 YES
Neurology 6_4 YES
Neurology 6_5 YES
Neurology 6_6 YES
Neurology 6_7 YES
Neurology 6_8 YES
Neurology 6_9 YES
Neurology 8_4 YES
Neurology 8_7 YES
Neurology 9_1 YES
Neurology 9_2 YES
Neurology 9_4 YES
Neurology 9_5 YES
Neurology 9_6 YES
Neurology 9_7 YES
Neurology 9_8 YES
Neurology 10_1 YES
Neurology 10_2 YES
Neurology 10_3 YES
Neurology 10_4 YES
Neurology 10_5 YES
Neurology 10_6 YES
Neurology 10_7 YES
Neurology 10_8 YES
Neurology 11_1 YES
Neurology 11_2 YES
Neurology 11_3 YES
Neurology 11_4 YES
Neurology 11_5 YES
Neurology 11_6 YES
Neurology 11_8 YES
Neurology 12_1 YES
Neurology 12_2 YES
Neurology 12_3 YES
Neurology 12_4 YES
Neurology 12_5 YES
Neurology 12_6 YES
Neurology 12_7 YES
Neurology 12_8 YES
Neurology 12_9 YES
Neurology 13_1 YES
Neurology 13_2 YES
Neurology 13_3 YES
Neurology 13_4 YES
Neurology 13_5 YES
Neurology 13_6 YES
Neurology 13_7 YES
Neurology 13_8 YES
Neurology 13_9 YES
Neurology 14_1 YES
Neurology 14_2 YES
Neurology 14_3 YES
Neurology 14_4 YES
Neurology 14_5 YES
Neurology 14_6 YES
Neurology 14_7 YES
Neurology 14_8 YES
Neurology 14_9 YES
Neurology 2_13 YES
Neurology 2_14 YES
Neurology 4_11 YES
Neurology 4_12 YES
Neurology 4_13 YES
Neurology 4_14 YES
Neurology 4_15 YES
Neurology 4_16 YES
Neurology 4_18 YES
Neurology 12_11 YES
Neurology 12_12 YES
Obsterics
Gyn 1_1 YES
Obsterics
Gyn 1_2 YES
Obsterics
Gyn 1_3 YES
Obsterics
Gyn 1_4 YES
Obsterics
Gyn 1_5 YES
Obsterics
Gyn 1_6 YES
Obsterics
Gyn 1_7 YES
Obsterics
Gyn 1_8 YES
Obsterics
Gyn 2_1 YES
Obsterics
Gyn 2_2 YES
Obsterics
Gyn 2_3 YES
Obsterics
Gyn 2_4 YES
Obsterics
Gyn 2_5 YES
Obsterics
Gyn 2_6 YES
Obsterics
Gyn 2_7 YES
Obsterics
Gyn 2_8 YES
Obsterics
Gyn 2_9 YES
Obsterics
Gyn 3_1 YES
Obsterics
Gyn 3_2 YES
Obsterics
Gyn 3_3 YES
Obsterics
Gyn 3_4 YES
Obsterics
Gyn 3_5 YES
Obsterics
Gyn 3_7 YES
Obsterics
Gyn 3_8 YES
Obsterics
Gyn 4_1 YES
Obsterics
Gyn 4_2 YES
Obsterics
Gyn 4_3 YES
Obsterics
Gyn 4_4 YES
Obsterics
Gyn 4_5 YES
Obsterics
Gyn 4_6 YES
Obsterics
Gyn 4_7 YES
Obsterics
Gyn 4_8 YES
Obsterics
Gyn 4_9 YES
Obsterics
Gyn 5_1 YES
Obsterics
Gyn 5_2 YES
Obsterics
Gyn 5_3 YES
Obsterics
Gyn 5_4 YES
Obsterics
Gyn 5_5 YES
Obsterics
Gyn 5_6 YES
Obsterics
Gyn 5_7 YES
Obsterics
Gyn 5_9 YES
Obsterics
Gyn 6_1 YES
Obsterics
Gyn 6_2 YES
Obsterics
Gyn 6_3 YES
Obsterics
Gyn 6_4 YES
Obsterics
Gyn 6_5 YES
Obsterics
Gyn 6_6 YES
Obsterics
Gyn 6_7 YES
Obsterics
Gyn 6_8 YES
Obsterics
Gyn 6_9 YES
Obsterics
Gyn 8_4 YES
Obsterics
Gyn 8_7 YES
Obsterics
Gyn 9_1 YES
Obsterics
Gyn 9_2 YES
Obsterics
Gyn 9_3 YES
Obsterics
Gyn 9_4 YES
Obsterics
Gyn 9_5 YES
Obsterics
Gyn 9_6 YES
Obsterics
Gyn 9_7 YES
Obsterics
Gyn 9_8 YES
Obsterics
Gyn 9_9 YES
Obsterics
Gyn 10_1 YES
Obsterics
Gyn 10_2 YES
Obsterics
Gyn 10_3 YES
Obsterics
Gyn 10_4 YES
Obsterics
Gyn 10_5 YES
Obsterics
Gyn 10_6 YES
Obsterics
Gyn 10_7 YES
Obsterics
Gyn 10_8 YES
Obsterics
Gyn 11_1 YES
Obsterics
Gyn 11_2 YES
Obsterics
Gyn 11_3 YES
Obsterics
Gyn 11_4 YES
Obsterics
Gyn 11_5 YES
Obsterics
Gyn 11_6 YES
Obsterics
Gyn 11_8 YES
Obsterics
Gyn 12_1 YES
Obsterics
Gyn 12_2 YES
Obsterics
Gyn 12_3 YES
Obsterics
Gyn 12_4 YES
Obsterics
Gyn 12_5 YES
Obsterics
Gyn 12_6 YES
Obsterics
Gyn 12_7 YES
Obsterics
Gyn 12_8 YES
Obsterics
Gyn 12_9 YES
Obsterics
Gyn 13_1 YES
Obsterics
Gyn 13_2 YES
Obsterics
Gyn 13_3 YES
Obsterics
Gyn 13_4 YES
Obsterics
Gyn 13_5 YES
Obsterics
Gyn 13_6 YES
Obsterics
Gyn 13_7 YES
Obsterics
Gyn 13_8 YES
Obsterics
Gyn 13_9 YES
Obsterics
Gyn 14_1 YES
Obsterics
Gyn 14_2 YES
Obsterics
Gyn 14_3 YES
Obsterics
Gyn 14_4 YES
Obsterics
Gyn 14_5 YES
Obsterics
Gyn 14_6 YES
Obsterics
Gyn 14_7 YES
Obsterics
Gyn 14_8 YES
Obsterics
Gyn 14_9 YES
Obsterics
Gyn 2_13 YES
Obsterics
Gyn 2_14 YES
Obsterics
Gyn 4_11 YES
Obsterics
Gyn 4_12 YES
Obsterics
Gyn 4_13 YES
Obsterics
Gyn 4_14 YES
Obsterics
Gyn 4_15 YES
Obsterics
Gyn 4_16 YES
Obsterics
Gyn 4_18 YES
Obsterics
Gyn 12_11 YES
Obsterics
Gyn 12_12 YES
Oncology 1_1 YES
Oncology 1_2 YES
Oncology 1_3 YES
Oncology 1_4 YES
Oncology 1_5 YES
Oncology 1_6 YES
Oncology 1_7 YES
Oncology 1_8 YES
Oncology 2_1 YES
Oncology 2_2 YES
Oncology 2_3 YES
Oncology 2_4 YES
Oncology 2_5 YES
Oncology 2_6 YES
Oncology 2_7 YES
Oncology 2_8 YES
Oncology 2_9 YES
Oncology 3_1 YES
Oncology 3_2 YES
Oncology 3_3 YES
Oncology 3_4 YES
Oncology 3_5 YES
Oncology 3_8 YES
Oncology 4_1 YES
Oncology 4_2 YES
Oncology 4_3 YES
Oncology 4_4 YES
Oncology 4_5 YES
Oncology 4_6 YES
Oncology 4_7 YES
Oncology 4_8 YES
Oncology 4_9 YES
Oncology 5_1 YES
Oncology 5_2 YES
Oncology 5_3 YES
Oncology 5_4 YES
Oncology 5_5 YES
Oncology 5_6 YES
Oncology 5_7 YES
Oncology 5_9 YES
Oncology 6_1 YES
Oncology 6_2 YES
Oncology 6_3 YES
Oncology 6_4 YES
Oncology 6_5 YES
Oncology 6_6 YES
Oncology 6_7 YES
Oncology 6_8 YES
Oncology 6_9 YES
Oncology 8_4 YES
Oncology 8_7 YES
Oncology 9_1 YES
Oncology 9_4 YES
Oncology 9_5 YES
Oncology 9_6 YES
Oncology 9_8 YES
Oncology 10_1 YES
Oncology 10_2 YES
Oncology 10_3 YES
Oncology 10_4 YES
Oncology 10_5 YES
Oncology 10_6 YES
Oncology 10_7 YES
Oncology 10_8 YES
Oncology 11_1 YES
Oncology 11_2 YES
Oncology 11_3 YES
Oncology 11_4 YES
Oncology 11_5 YES
Oncology 11_6 YES
Oncology 11_8 YES
Oncology 12_1 YES
Oncology 12_2 YES
Oncology 12_3 YES
Oncology 12_4 YES
Oncology 12_5 YES
Oncology 12_6 YES
Oncology 12_7 YES
Oncology 12_8 YES
Oncology 12_9 YES
Oncology 13_1 YES
Oncology 13_2 YES
Oncology 13_3 YES
Oncology 13_4 YES
Oncology 13_5 YES
Oncology 13_6 YES
Oncology 13_7 YES
Oncology 13_8 YES
Oncology 13_9 YES
Oncology 14_1 YES
Oncology 14_2 YES
Oncology 14_3 YES
Oncology 14_4 YES
Oncology 14_5 YES
Oncology 14_6 YES
Oncology 14_7 YES
Oncology 14_8 YES
Oncology 14_9 YES
Oncology 2_13 YES
Oncology 4_11 YES
Oncology 4_12 YES
Oncology 4_13 YES
Oncology 4_14 YES
Oncology 4_15 YES
Oncology 4_16 YES
Oncology 4_17 YES
Oncology 4_18 YES
Oncology 12_11 YES
Oncology 12_12 YES
Orthopedics 1_1 YES
Orthopedics 1_2 YES
Orthopedics 1_3 YES
Orthopedics 1_4 YES
Orthopedics 1_5 YES
Orthopedics 1_6 YES
Orthopedics 1_7 YES
Orthopedics 1_8 YES
Orthopedics 2_1 YES
Orthopedics 2_2 YES
Orthopedics 2_3 YES
Orthopedics 2_4 YES
Orthopedics 2_5 YES
Orthopedics 2_6 YES
Orthopedics 2_7 YES
Orthopedics 2_8 YES
Orthopedics 2_9 YES
Orthopedics 3_1 YES
Orthopedics 3_2 YES
Orthopedics 3_3 YES
Orthopedics 3_4 YES
Orthopedics 3_5 YES
Orthopedics 3_8 YES
Orthopedics 4_1 YES
Orthopedics 4_2 YES
Orthopedics 4_3 YES
Orthopedics 4_4 YES
Orthopedics 4_5 YES
Orthopedics 4_6 YES
Orthopedics 4_7 YES
Orthopedics 4_8 YES
Orthopedics 4_9 YES
Orthopedics 5_1 YES
Orthopedics 5_2 YES
Orthopedics 5_3 YES
Orthopedics 5_4 YES
Orthopedics 5_5 YES
Orthopedics 5_6 YES
Orthopedics 5_7 YES
Orthopedics 5_9 YES
Orthopedics 6_1 YES
Orthopedics 6_2 YES
Orthopedics 6_3 YES
Orthopedics 6_4 YES
Orthopedics 6_5 YES
Orthopedics 6_6 YES
Orthopedics 6_7 YES
Orthopedics 6_8 YES
Orthopedics 6_9 YES
Orthopedics 8_4 YES
Orthopedics 8_7 YES
Orthopedics 9_1 YES
Orthopedics 9_4 YES
Orthopedics 9_5 YES
Orthopedics 9_6 YES
Orthopedics 9_7 YES
Orthopedics 9_8 YES
Orthopedics 10_1 YES
Orthopedics 10_2 YES
Orthopedics 10_3 YES
Orthopedics 10_4 YES
Orthopedics 10_5 YES
Orthopedics 10_6 YES
Orthopedics 10_7 YES
Orthopedics 10_8 YES
Orthopedics 12_1 YES
Orthopedics 12_2 YES
Orthopedics 12_3 YES
Orthopedics 12_4 YES
Orthopedics 12_5 YES
Orthopedics 12_6 YES
Orthopedics 12_7 YES
Orthopedics 12_8 YES
Orthopedics 12_9 YES
Orthopedics 13_1 YES
Orthopedics 13_2 YES
Orthopedics 13_3 YES
Orthopedics 13_4 YES
Orthopedics 13_5 YES
Orthopedics 13_6 YES
Orthopedics 13_7 YES
Orthopedics 13_8 YES
Orthopedics 13_9 YES
Orthopedics 14_1 YES
Orthopedics 14_2 YES
Orthopedics 14_3 YES
Orthopedics 14_4 YES
Orthopedics 14_5 YES
Orthopedics 14_6 YES
Orthopedics 14_7 YES
Orthopedics 14_8 YES
Orthopedics 14_9 YES
Orthopedics 2_13 YES
Orthopedics 4_11 YES
Orthopedics 4_12 YES
Orthopedics 4_13 YES
Orthopedics 4_14 YES
Orthopedics 4_15 YES
Orthopedics 4_16 YES
Orthopedics 4_18 YES
Orthopedics 12_11 YES
Orthopedics 12_12 YES
Otolaryngology 1_1 YES
Otolaryngology 1_2 YES
Otolaryngology 1_3 YES
Otolaryngology 1_4 YES
Otolaryngology 1_5 YES
Otolaryngology 1_6 YES
Otolaryngology 1_7 YES
Otolaryngology 1_8 YES
Otolaryngology 2_1 YES
Otolaryngology 2_2 YES
Otolaryngology 2_3 YES
Otolaryngology 2_4 YES
Otolaryngology 2_5 YES
Otolaryngology 2_6 YES
Otolaryngology 2_7 YES
Otolaryngology 2_8 YES
Otolaryngology 2_9 YES
Otolaryngology 3_1 YES
Otolaryngology 3_2 YES
Otolaryngology 3_3 YES
Otolaryngology 3_4 YES
Otolaryngology 3_5 YES
Otolaryngology 3_8 YES
Otolaryngology 4_1 YES
Otolaryngology 4_2 YES
Otolaryngology 4_3 YES
Otolaryngology 4_4 YES
Otolaryngology 4_5 YES
Otolaryngology 4_6 YES
Otolaryngology 4_7 YES
Otolaryngology 4_8 YES
Otolaryngology 4_9 YES
Otolaryngology 5_1 YES
Otolaryngology 5_2 YES
Otolaryngology 5_3 YES
Otolaryngology 5_4 YES
Otolaryngology 5_5 YES
Otolaryngology 5_6 YES
Otolaryngology 5_7 YES
Otolaryngology 5_9 YES
Otolaryngology 6_1 YES
Otolaryngology 6_2 YES
Otolaryngology 6_3 YES
Otolaryngology 6_4 YES
Otolaryngology 6_5 YES
Otolaryngology 6_6 YES
Otolaryngology 6_7 YES
Otolaryngology 6_8 YES
Otolaryngology 6_9 YES
Otolaryngology 8_4 YES
Otolaryngology 8_7 YES
Otolaryngology 9_1 YES
Otolaryngology 9_4 YES
Otolaryngology 9_5 YES
Otolaryngology 9_6 YES
Otolaryngology 9_8 YES
Otolaryngology 10_1 YES
Otolaryngology 10_2 YES
Otolaryngology 10_3 YES
Otolaryngology 10_4 YES
Otolaryngology 10_5 YES
Otolaryngology 10_6 YES
Otolaryngology 10_7 YES
Otolaryngology 10_8 YES
Otolaryngology 12_1 YES
Otolaryngology 12_2 YES
Otolaryngology 12_3 YES
Otolaryngology 12_4 YES
Otolaryngology 12_5 YES
Otolaryngology 12_6 YES
Otolaryngology 12_7 YES
Otolaryngology 12_8 YES
Otolaryngology 12_9 YES
Otolaryngology 13_1 YES
Otolaryngology 13_2 YES
Otolaryngology 13_3 YES
Otolaryngology 13_4 YES
Otolaryngology 13_5 YES
Otolaryngology 13_6 YES
Otolaryngology 13_7 YES
Otolaryngology 13_8 YES
Otolaryngology 13_9 YES
Otolaryngology 14_1 YES
Otolaryngology 14_2 YES
Otolaryngology 14_3 YES
Otolaryngology 14_4 YES
Otolaryngology 14_5 YES
Otolaryngology 14_6 YES
Otolaryngology 14_7 YES
Otolaryngology 14_8 YES
Otolaryngology 14_9 YES
Otolaryngology 2_13 YES
Otolaryngology 4_11 YES
Otolaryngology 4_12 YES
Otolaryngology 4_13 YES
Otolaryngology 4_14 YES
Otolaryngology 4_15 YES
Otolaryngology 4_16 YES
Otolaryngology 4_18 YES
Otolaryngology 12_11 YES
Otolaryngology 12_12 YES
Pain
Mngt 1_1 YES
Pain
Mngt 1_2 YES
Pain
Mngt 1_3 YES
Pain
Mngt 1_4 YES
Pain
Mngt 1_5 YES
Pain
Mngt 1_6 YES
Pain
Mngt 1_7 YES
Pain
Mngt 1_8 YES
Pain
Mngt 2_1 YES
Pain
Mngt 2_2 YES
Pain
Mngt 2_3 YES
Pain
Mngt 2_4 YES
Pain
Mngt 2_5 YES
Pain
Mngt 2_7 YES
Pain
Mngt 2_8 YES
Pain
Mngt 2_9 YES
Pain
Mngt 3_1 YES
Pain
Mngt 3_2 YES
Pain
Mngt 3_3 YES
Pain
Mngt 3_4 YES
Pain
Mngt 3_5 YES
Pain
Mngt 3_8 YES
Pain
Mngt 4_1 YES
Pain
Mngt 4_2 YES
Pain
Mngt 4_3 YES
Pain
Mngt 4_4 YES
Pain
Mngt 4_5 YES
Pain
Mngt 4_6 YES
Pain
Mngt 4_7 YES
Pain
Mngt 4_8 YES
Pain
Mngt 5_1 YES
Pain
Mngt 5_2 YES
Pain
Mngt 5_3 YES
Pain
Mngt 5_4 YES
Pain
Mngt 5_5 YES
Pain
Mngt 5_6 YES
Pain
Mngt 5_7 YES
Pain
Mngt 5_9 YES
Pain
Mngt 6_1 YES
Pain
Mngt 6_2 YES
Pain
Mngt 6_3 YES
Pain
Mngt 6_4 YES
Pain
Mngt 6_5 YES
Pain
Mngt 6_6 YES
Pain
Mngt 6_7 YES
Pain
Mngt 6_8 YES
Pain
Mngt 6_9 YES
Pain
Mngt 8_4 YES
Pain
Mngt 8_7 YES
Pain
Mngt 9_4 YES
Pain
Mngt 9_5 YES
Pain
Mngt 9_6 YES
Pain
Mngt 9_8 YES
Pain
Mngt 10_1 YES
Pain
Mngt 10_2 YES
Pain
Mngt 10_3 YES
Pain
Mngt 10_4 YES
Pain
Mngt 10_5 YES
Pain
Mngt 10_6 YES
Pain
Mngt 10_7 YES
Pain
Mngt 10_8 YES
Pain
Mngt 11_1 YES
Pain
Mngt 11_2 YES
Pain
Mngt 11_3 YES
Pain
Mngt 11_4 YES
Pain
Mngt 11_5 YES
Pain
Mngt 11_6 YES
Pain
Mngt 11_8 YES
Pain
Mngt 12_1 YES
Pain
Mngt 12_2 YES
Pain
Mngt 13_1 YES
Pain
Mngt 13_2 YES
Pain
Mngt 13_3 YES
Pain
Mngt 13_4 YES
Pain
Mngt 13_5 YES
Pain
Mngt 13_6 YES
Pain
Mngt 13_7 YES
Pain
Mngt 13_8 YES
Pain
Mngt 13_9 YES
Pain
Mngt 14_1 YES
Pain
Mngt 14_2 YES
Pain
Mngt 14_3 YES
Pain
Mngt 14_4 YES
Pain
Mngt 14_5 YES
Pain
Mngt 14_6 YES
Pain
Mngt 14_7 YES
Pain
Mngt 14_8 YES
Pain
Mngt 14_9 YES
Pain
Mngt 2_13 YES
Pain
Mngt 4_11 YES
Pain
Mngt 4_12 YES
Pain
Mngt 4_13 YES
Pain
Mngt 4_14 YES
Pain
Mngt 4_16 YES
Pain
Mngt 4_18 YES
Physicial
Medicine 1_1 YES
Physicial
Medicine 1_2 YES
Physicial
Medicine 1_3 YES
Physicial
Medicine 1_4 YES
Physicial
Medicine 1_5 YES
Physicial
Medicine 1_6 YES
Physicial
Medicine 1_7 YES
Physicial
Medicine 1_8 YES
Physicial
Medicine 2_1 YES
Physicial
Medicine 2_2 YES
Physicial
Medicine 2_3 YES
Physicial
Medicine 2_4 YES
Physicial
Medicine 2_5 YES
Physicial
Medicine 2_6 YES
Physicial
Medicine 2_7 YES
Physicial
Medicine 2_8 YES
Physicial
Medicine 2_9 YES
Physicial
Medicine 3_1 YES
Physicial
Medicine 3_2 YES
Physicial
Medicine 3_3 YES
Physicial
Medicine 3_4 YES
Physicial
Medicine 3_5 YES
Physicial
Medicine 3_8 YES
Physicial
Medicine 4_1 YES
Physicial
Medicine 4_2 YES
Physicial
Medicine 4_3 YES
Physicial
Medicine 4_4 YES
Physicial
Medicine 4_5 YES
Physicial
Medicine 4_6 YES
Physicial
Medicine 4_7 YES
Physicial
Medicine 4_8 YES
Physicial
Medicine 5_1 YES
Physicial
Medicine 5_2 YES
Physicial
Medicine 5_3 YES
Physicial
Medicine 5_4 YES
Physicial
Medicine 5_5 YES
Physicial
Medicine 5_6 YES
Physicial
Medicine 5_7 YES
Physicial
Medicine 5_9 YES
Physicial
Medicine 6_1 YES
Physicial
Medicine 6_2 YES
Physicial
Medicine 6_3 YES
Physicial
Medicine 6_4 YES
Physicial
Medicine 6_5 YES
Physicial
Medicine 6_6 YES
Physicial
Medicine 6_7 YES
Physicial
Medicine 6_8 YES
Physicial
Medicine 6_9 YES
Physicial
Medicine 8_4 YES
Physicial
Medicine 8_7 YES
Physicial
Medicine 9_1 YES
Physicial
Medicine 9_2 YES
Physicial
Medicine 9_4 YES
Physicial
Medicine 9_5 YES
Physicial
Medicine 9_6 YES
Physicial
Medicine 9_7 YES
Physicial
Medicine 9_8 YES
Physicial
Medicine 10_1 YES
Physicial
Medicine 10_2 YES
Physicial
Medicine 10_3 YES
Physicial
Medicine 10_4 YES
Physicial
Medicine 10_5 YES
Physicial
Medicine 10_6 YES
Physicial
Medicine 10_7 YES
Physicial
Medicine 10_8 YES
Physicial
Medicine 11_1 YES
Physicial
Medicine 11_2 YES
Physicial
Medicine 11_3 YES
Physicial
Medicine 11_4 YES
Physicial
Medicine 11_5 YES
Physicial
Medicine 11_6 YES
Physicial
Medicine 11_8 YES
Physicial
Medicine 12_1 YES
Physicial
Medicine 12_2 YES
Physicial
Medicine 12_3 YES
Physicial
Medicine 12_4 YES
Physicial
Medicine 12_5 YES
Physicial
Medicine 12_6 YES
Physicial
Medicine 12_7 YES
Physicial
Medicine 12_8 YES
Physicial
Medicine 12_9 YES
Physicial
Medicine 13_1 YES
Physicial
Medicine 13_2 YES
Physicial
Medicine 13_3 YES
Physicial
Medicine 13_4 YES
Physicial
Medicine 13_5 YES
Physicial
Medicine 13_6 YES
Physicial
Medicine 13_7 YES
Physicial
Medicine 13_8 YES
Physicial
Medicine 13_9 YES
Physicial
Medicine 14_1 YES
Physicial
Medicine 14_2 YES
Physicial
Medicine 14_3 YES
Physicial
Medicine 14_4 YES
Physicial
Medicine 14_5 YES
Physicial
Medicine 14_6 YES
Physicial
Medicine 14_7 YES
Physicial
Medicine 14_8 YES
Physicial
Medicine 14_9 YES
Physicial
Medicine 2_13 YES
Physicial
Medicine 4_11 YES
Physicial
Medicine 4_12 YES
Physicial
Medicine 4_13 YES
Physicial
Medicine 4_14 YES
Physicial
Medicine 4_16 YES
Physicial
Medicine 4_18 YES
Physicial
Medicine 12_11 YES
Physicial
Medicine 12_12 YES
Podiatry 1_1 YES
Podiatry 1_2 YES
Podiatry 1_3 YES
Podiatry 1_4 YES
Podiatry 1_5 YES
Podiatry 1_6 YES
Podiatry 1_7 YES
Podiatry 1_8 YES
Podiatry 2_1 YES
Podiatry 2_2 YES
Podiatry 2_3 YES
Podiatry 2_4 YES
Podiatry 2_5 YES
Podiatry 2_6 YES
Podiatry 2_7 YES
Podiatry 2_8 YES
Podiatry 2_9 YES
Podiatry 3_1 YES
Podiatry 3_2 YES
Podiatry 3_3 YES
Podiatry 3_4 YES
Podiatry 3_5 YES
Podiatry 3_8 YES
Podiatry 4_1 YES
Podiatry 4_3 YES
Podiatry 4_4 YES
Podiatry 4_5 YES
Podiatry 4_6 YES
Podiatry 4_7 YES
Podiatry 4_8 YES
Podiatry 4_9 YES
Podiatry 5_1 YES
Podiatry 5_3 YES
Podiatry 5_4 YES
Podiatry 5_5 YES
Podiatry 5_6 YES
Podiatry 5_7 YES
Podiatry 5_9 YES
Podiatry 6_1 YES
Podiatry 6_2 YES
Podiatry 6_3 YES
Podiatry 6_4 YES
Podiatry 6_5 YES
Podiatry 6_6 YES
Podiatry 6_7 YES
Podiatry 6_8 YES
Podiatry 6_9 YES
Podiatry 8_4 YES
Podiatry 8_7 YES
Podiatry 9_1 YES
Podiatry 9_2 YES
Podiatry 9_4 YES
Podiatry 9_5 YES
Podiatry 9_6 YES
Podiatry 9_7 YES
Podiatry 9_8 YES
Podiatry 10_1 YES
Podiatry 10_2 YES
Podiatry 10_3 YES
Podiatry 10_4 YES
Podiatry 10_5 YES
Podiatry 10_6 YES
Podiatry 10_7 YES
Podiatry 10_8 YES
Podiatry 11_1 YES
Podiatry 11_2 YES
Podiatry 11_3 YES
Podiatry 11_4 YES
Podiatry 11_5 YES
Podiatry 11_6 YES
Podiatry 11_8 YES
Podiatry 12_1 YES
Podiatry 12_2 YES
Podiatry 12_3 YES
Podiatry 12_4 YES
Podiatry 12_5 YES
Podiatry 12_6 YES
Podiatry 12_7 YES
Podiatry 12_8 YES
Podiatry 12_9 YES
Podiatry 13_1 YES
Podiatry 13_2 YES
Podiatry 13_3 YES
Podiatry 13_4 YES
Podiatry 13_5 YES
Podiatry 13_6 YES
Podiatry 13_7 YES
Podiatry 13_8 YES
Podiatry 13_9 YES
Podiatry 14_1 YES
Podiatry 14_2 YES
Podiatry 14_3 YES
Podiatry 14_4 YES
Podiatry 14_5 YES
Podiatry 14_6 YES
Podiatry 14_7 YES
Podiatry 14_8 YES
Podiatry 14_9 YES
Podiatry 2_13 YES
Podiatry 2_14 YES
Podiatry 4_11 YES
Podiatry 4_12 YES
Podiatry 4_13 YES
Podiatry 4_14 YES
Podiatry 4_15 YES
Podiatry 4_16 YES
Podiatry 12_11 YES
Podiatry 12_12 YES
Psychiatry 1_1 YES
Psychiatry 1_2 YES
Psychiatry 1_3 YES
Psychiatry 1_4 YES
Psychiatry 1_5 YES
Psychiatry 1_6 YES
Psychiatry 1_7 YES
Psychiatry 1_8 YES
Psychiatry 2_1 YES
Psychiatry 2_2 YES
Psychiatry 2_3 YES
Psychiatry 2_4 YES
Psychiatry 2_5 YES
Psychiatry 2_8 YES
Psychiatry 2_9 YES
Psychiatry 3_1 YES
Psychiatry 3_2 YES
Psychiatry 3_3 YES
Psychiatry 3_4 YES
Psychiatry 3_5 YES
Psychiatry 4_1 YES
Psychiatry 4_3 YES
Psychiatry 4_4 YES
Psychiatry 4_5 YES
Psychiatry 4_6 YES
Psychiatry 4_7 YES
Psychiatry 4_8 YES
Psychiatry 5_1 YES
Psychiatry 5_2 YES
Psychiatry 5_3 YES
Psychiatry 5_4 YES
Psychiatry 5_5 YES
Psychiatry 5_6 YES
Psychiatry 5_7 YES
Psychiatry 5_9 YES
Psychiatry 6_1 YES
Psychiatry 6_2 YES
Psychiatry 6_3 YES
Psychiatry 6_4 YES
Psychiatry 6_5 YES
Psychiatry 6_6 YES
Psychiatry 6_7 YES
Psychiatry 6_8 YES
Psychiatry 6_9 YES
Psychiatry 8_4 YES
Psychiatry 8_7 YES
Psychiatry 9_4 YES
Psychiatry 9_5 YES
Psychiatry 9_6 YES
Psychiatry 9_8 YES
Psychiatry 10_1 YES
Psychiatry 10_2 YES
Psychiatry 10_3 YES
Psychiatry 10_4 YES
Psychiatry 10_5 YES
Psychiatry 10_6 YES
Psychiatry 10_7 YES
Psychiatry 10_8 YES
Psychiatry 11_1 YES
Psychiatry 11_2 YES
Psychiatry 11_3 YES
Psychiatry 11_4 YES
Psychiatry 11_5 YES
Psychiatry 11_6 YES
Psychiatry 11_8 YES
Psychiatry 12_1 YES
Psychiatry 12_2 YES
Psychiatry 13_1 YES
Psychiatry 13_4 YES
Psychiatry 13_5 YES
Psychiatry 13_6 YES
Psychiatry 13_7 YES
Psychiatry 13_8 YES
Psychiatry 13_9 YES
Psychiatry 14_1 YES
Psychiatry 14_2 YES
Psychiatry 14_3 YES
Psychiatry 14_5 YES
Psychiatry 14_6 YES
Psychiatry 14_7 YES
Psychiatry 14_8 YES
Psychiatry 14_9 YES
Psychiatry 2_13 YES
Psychiatry 4_11 YES
Psychiatry 4_12 YES
Psychiatry 4_13 YES
Psychiatry 4_14 YES
Psychiatry 4_16 YES
Psychiatry 4_18 YES
Psychology 1_1 YES
Psychology 1_2 YES
Psychology 1_3 YES
Psychology 1_4 YES
Psychology 1_5 YES
Psychology 1_6 YES
Psychology 1_7 YES
Psychology 1_8 YES
Psychology 2_1 YES
Psychology 2_2 YES
Psychology 2_3 YES
Psychology 2_4 YES
Psychology 2_5 YES
Psychology 2_8 YES
Psychology 2_9 YES
Psychology 3_1 YES
Psychology 3_2 YES
Psychology 3_3 YES
Psychology 3_4 YES
Psychology 3_5 YES
Psychology 4_1 YES
Psychology 4_3 YES
Psychology 4_4 YES
Psychology 4_5 YES
Psychology 4_6 YES
Psychology 4_7 YES
Psychology 4_8 YES
Psychology 4_9 YES
Psychology 5_1 YES
Psychology 5_3 YES
Psychology 5_4 YES
Psychology 5_5 YES
Psychology 5_6 YES
Psychology 5_7 YES
Psychology 5_9 YES
Psychology 6_1 YES
Psychology 6_2 YES
Psychology 6_3 YES
Psychology 6_4 YES
Psychology 6_5 YES
Psychology 6_6 YES
Psychology 6_7 YES
Psychology 6_8 YES
Psychology 6_9 YES
Psychology 8_4 YES
Psychology 8_7 YES
Psychology 9_4 YES
Psychology 9_5 YES
Psychology 9_6 YES
Psychology 9_8 YES
Psychology 10_1 YES
Psychology 10_2 YES
Psychology 10_3 YES
Psychology 10_4 YES
Psychology 10_5 YES
Psychology 10_6 YES
Psychology 10_7 YES
Psychology 10_8 YES
Psychology 12_1 YES
Psychology 12_2 YES
Psychology 13_1 YES
Psychology 13_4 YES
Psychology 13_5 YES
Psychology 13_6 YES
Psychology 13_7 YES
Psychology 13_8 YES
Psychology 13_9 YES
Psychology 14_1 YES
Psychology 14_2 YES
Psychology 14_3 YES
Psychology 14_5 YES
Psychology 14_6 YES
Psychology 14_7 YES
Psychology 14_8 YES
Psychology 14_9 YES
Psychology 2_13 YES
Psychology 4_11 YES
Psychology 4_12 YES
Psychology 4_13 YES
Psychology 4_14 YES
Psychology 4_15 YES
Psychology 4_16 YES
Psychology 4_18 YES
Pulmonology 1_1 YES
Pulmonology 1_2 YES
Pulmonology 1_3 YES
Pulmonology 1_4 YES
Pulmonology 1_5 YES
Pulmonology 1_6 YES
Pulmonology 1_7 YES
Pulmonology 1_8 YES
Pulmonology 2_1 YES
Pulmonology 2_2 YES
Pulmonology 2_3 YES
Pulmonology 2_4 YES
Pulmonology 2_5 YES
Pulmonology 2_6 YES
Pulmonology 2_7 YES
Pulmonology 2_8 YES
Pulmonology 2_9 YES
Pulmonology 3_1 YES
Pulmonology 3_2 YES
Pulmonology 3_3 YES
Pulmonology 3_4 YES
Pulmonology 3_5 YES
Pulmonology 3_8 YES
Pulmonology 4_1 YES
Pulmonology 4_2 YES
Pulmonology 4_3 YES
Pulmonology 4_4 YES
Pulmonology 4_5 YES
Pulmonology 4_6 YES
Pulmonology 4_7 YES
Pulmonology 4_8 YES
Pulmonology 4_9 YES
Pulmonology 5_1 YES
Pulmonology 5_2 YES
Pulmonology 5_3 YES
Pulmonology 5_4 YES
Pulmonology 5_5 YES
Pulmonology 5_6 YES
Pulmonology 5_7 YES
Pulmonology 5_9 YES
Pulmonology 6_1 YES
Pulmonology 6_2 YES
Pulmonology 6_3 YES
Pulmonology 6_4 YES
Pulmonology 6_5 YES
Pulmonology 6_6 YES
Pulmonology 6_7 YES
Pulmonology 6_8 YES
Pulmonology 6_9 YES
Pulmonology 8_4 YES
Pulmonology 8_7 YES
Pulmonology 9_1 YES
Pulmonology 9_2 YES
Pulmonology 9_4 YES
Pulmonology 9_5 YES
Pulmonology 9_6 YES
Pulmonology 9_7 YES
Pulmonology 9_8 YES
Pulmonology 10_1 YES
Pulmonology 10_2 YES
Pulmonology 10_3 YES
Pulmonology 10_4 YES
Pulmonology 10_5 YES
Pulmonology 10_6 YES
Pulmonology 10_7 YES
Pulmonology 10_8 YES
Pulmonology 11_1 YES
Pulmonology 11_2 YES
Pulmonology 11_3 YES
Pulmonology 11_4 YES
Pulmonology 11_5 YES
Pulmonology 11_6 YES
Pulmonology 11_8 YES
Pulmonology 12_1 YES
Pulmonology 12_2 YES
Pulmonology 12_3 YES
Pulmonology 12_4 YES
Pulmonology 12_5 YES
Pulmonology 12_6 YES
Pulmonology 12_7 YES
Pulmonology 12_8 YES
Pulmonology 12_9 YES
Pulmonology 13_1 YES
Pulmonology 13_2 YES
Pulmonology 13_3 YES
Pulmonology 13_4 YES
Pulmonology 13_5 YES
Pulmonology 13_6 YES
Pulmonology 13_7 YES
Pulmonology 13_8 YES
Pulmonology 13_9 YES
Pulmonology 14_1 YES
Pulmonology 14_2 YES
Pulmonology 14_3 YES
Pulmonology 14_4 YES
Pulmonology 14_5 YES
Pulmonology 14_6 YES
Pulmonology 14_7 YES
Pulmonology 14_8 YES
Pulmonology 14_9 YES
Pulmonology 2_13 YES
Pulmonology 4_11 YES
Pulmonology 4_12 YES
Pulmonology 4_13 YES
Pulmonology 4_14 YES
Pulmonology 4_15 YES
Pulmonology 4_16 YES
Pulmonology 4_18 YES
Pulmonology 12_11 YES
Pulmonology 12_12 YES
Rheumatology 1_1 YES
Rheumatology 1_2 YES
Rheumatology 1_3 YES
Rheumatology 1_4 YES
Rheumatology 1_5 YES
Rheumatology 1_6 YES
Rheumatology 1_7 YES
Rheumatology 1_8 YES
Rheumatology 2_1 YES
Rheumatology 2_2 YES
Rheumatology 2_3 YES
Rheumatology 2_4 YES
Rheumatology 2_5 YES
Rheumatology 2_6 YES
Rheumatology 2_7 YES
Rheumatology 2_8 YES
Rheumatology 2_9 YES
Rheumatology 3_1 YES
Rheumatology 3_2 YES
Rheumatology 3_3 YES
Rheumatology 3_4 YES
Rheumatology 3_5 YES
Rheumatology 3_8 YES
Rheumatology 4_1 YES
Rheumatology 4_2 YES
Rheumatology 4_3 YES
Rheumatology 4_4 YES
Rheumatology 4_5 YES
Rheumatology 4_6 YES
Rheumatology 4_7 YES
Rheumatology 4_8 YES
Rheumatology 4_9 YES
Rheumatology 5_1 YES
Rheumatology 5_2 YES
Rheumatology 5_3 YES
Rheumatology 5_4 YES
Rheumatology 5_5 YES
Rheumatology 5_6 YES
Rheumatology 5_7 YES
Rheumatology 5_9 YES
Rheumatology 6_1 YES
Rheumatology 6_2 YES
Rheumatology 6_3 YES
Rheumatology 6_4 YES
Rheumatology 6_5 YES
Rheumatology 6_6 YES
Rheumatology 6_7 YES
Rheumatology 6_8 YES
Rheumatology 6_9 YES
Rheumatology 8_4 YES
Rheumatology 8_7 YES
Rheumatology 9_1 YES
Rheumatology 9_4 YES
Rheumatology 9_5 YES
Rheumatology 9_6 YES
Rheumatology 9_7 YES
Rheumatology 9_8 YES
Rheumatology 10_1 YES
Rheumatology 10_2 YES
Rheumatology 10_3 YES
Rheumatology 10_4 YES
Rheumatology 10_5 YES
Rheumatology 10_6 YES
Rheumatology 10_7 YES
Rheumatology 10_8 YES
Rheumatology 11_1 YES
Rheumatology 11_2 YES
Rheumatology 11_3 YES
Rheumatology 11_4 YES
Rheumatology 11_5 YES
Rheumatology 11_6 YES
Rheumatology 11_8 YES
Rheumatology 12_1 YES
Rheumatology 12_2 YES
Rheumatology 12_3 YES
Rheumatology 12_4 YES
Rheumatology 12_5 YES
Rheumatology 12_6 YES
Rheumatology 12_7 YES
Rheumatology 12_8 YES
Rheumatology 12_9 YES
Rheumatology 13_1 YES
Rheumatology 13_2 YES
Rheumatology 13_3 YES
Rheumatology 13_4 YES
Rheumatology 13_5 YES
Rheumatology 13_6 YES
Rheumatology 13_7 YES
Rheumatology 13_8 YES
Rheumatology 13_9 YES
Rheumatology 14_1 YES
Rheumatology 14_2 YES
Rheumatology 14_3 YES
Rheumatology 14_4 YES
Rheumatology 14_5 YES
Rheumatology 14_6 YES
Rheumatology 14_7 YES
Rheumatology 14_8 YES
Rheumatology 14_9 YES
Rheumatology 2_13 YES
Rheumatology 4_11 YES
Rheumatology 4_12 YES
Rheumatology 4_13 YES
Rheumatology 4_14 YES
Rheumatology 4_15 YES
Rheumatology 4_16 YES
Rheumatology 4_18 YES
Rheumatology 12_11 YES
Rheumatology 12_12 YES
Sports
Medicine 1_1 YES
Sports
Medicine 1_2 YES
Sports
Medicine 1_3 YES
Sports
Medicine 1_4 YES
Sports
Medicine 1_5 YES
Sports
Medicine 1_6 YES
Sports
Medicine 1_7 YES
Sports
Medicine 1_8 YES
Sports
Medicine 2_1 YES
Sports
Medicine 2_2 YES
Sports
Medicine 2_3 YES
Sports
Medicine 2_4 YES
Sports
Medicine 2_5 YES
Sports
Medicine 2_6 YES
Sports
Medicine 2_7 YES
Sports
Medicine 2_8 YES
Sports
Medicine 2_9 YES
Sports
Medicine 3_1 YES
Sports
Medicine 3_2 YES
Sports
Medicine 3_3 YES
Sports
Medicine 3_4 YES
Sports
Medicine 3_5 YES
Sports
Medicine 3_8 YES
Sports
Medicine 4_1 YES
Sports
Medicine 4_2 YES
Sports
Medicine 4_3 YES
Sports
Medicine 4_4 YES
Sports
Medicine 4_5 YES
Sports
Medicine 4_6 YES
Sports
Medicine 4_7 YES
Sports
Medicine 4_8 YES
Sports
Medicine 5_1 YES
Sports
Medicine 5_2 YES
Sports
Medicine 5_3 YES
Sports
Medicine 5_4 YES
Sports
Medicine 5_5 YES
Sports
Medicine 5_6 YES
Sports
Medicine 5_7 YES
Sports
Medicine 5_9 YES
Sports
Medicine 6_1 YES
Sports
Medicine 6_2 YES
Sports
Medicine 6_3 YES
Sports
Medicine 6_4 YES
Sports
Medicine 6_5 YES
Sports
Medicine 6_6 YES
Sports
Medicine 6_7 YES
Sports
Medicine 6_8 YES
Sports
Medicine 6_9 YES
Sports
Medicine 8_4 YES
Sports
Medicine 8_7 YES
Sports
Medicine 9_1 YES
Sports
Medicine 9_2 YES
Sports
Medicine 9_4 YES
Sports
Medicine 9_5 YES
Sports
Medicine 9_6 YES
Sports
Medicine 9_7 YES
Sports
Medicine 9_8 YES
Sports
Medicine 10_1 YES
Sports
Medicine 10_2 YES
Sports
Medicine 10_3 YES
Sports
Medicine 10_4 YES
Sports
Medicine 10_5 YES
Sports
Medicine 10_6 YES
Sports
Medicine 10_7 YES
Sports
Medicine 10_8 YES
Sports
Medicine 11_1 YES
Sports
Medicine 11_2 YES
Sports
Medicine 11_3 YES
Sports
Medicine 11_4 YES
Sports
Medicine 11_5 YES
Sports
Medicine 11_6 YES
Sports
Medicine 11_8 YES
Sports
Medicine 12_1 YES
Sports
Medicine 12_2 YES
Sports
Medicine 12_3 YES
Sports
Medicine 12_4 YES
Sports
Medicine 12_5 YES
Sports
Medicine 12_6 YES
Sports
Medicine 12_7 YES
Sports
Medicine 12_8 YES
Sports
Medicine 12_9 YES
Sports
Medicine 13_1 YES
Sports
Medicine 13_2 YES
Sports
Medicine 13_3 YES
Sports
Medicine 13_4 YES
Sports
Medicine 13_5 YES
Sports
Medicine 13_6 YES
Sports
Medicine 13_7 YES
Sports
Medicine 13_8 YES
Sports
Medicine 13_9 YES
Sports
Medicine 14_1 YES
Sports
Medicine 14_2 YES
Sports
Medicine 14_3 YES
Sports
Medicine 14_4 YES
Sports
Medicine 14_5 YES
Sports
Medicine 14_6 YES
Sports
Medicine 14_7 YES
Sports
Medicine 14_8 YES
Sports
Medicine 14_9 YES
Sports
Medicine 2_13 YES
Sports
Medicine 4_11 YES
Sports
Medicine 4_12 YES
Sports
Medicine 4_13 YES
Sports
Medicine 4_14 YES
Sports
Medicine 4_16 YES
Sports
Medicine 4_18 YES
Sports
Medicine 12_11 YES
Sports
Medicine 12_12 YES
Urology 1_1 YES
Urology 1_2 YES
Urology 1_3 YES
Urology 1_4 YES
Urology 1_5 YES
Urology 1_6 YES
Urology 1_7 YES
Urology 1_8 YES
Urology 2_1 YES
Urology 2_2 YES
Urology 2_3 YES
Urology 2_4 YES
Urology 2_5 YES
Urology 2_6 YES
Urology 2_7 YES
Urology 2_8 YES
Urology 2_9 YES
Urology 3_1 YES
Urology 3_2 YES
Urology 3_3 YES
Urology 3_4 YES
Urology 3_5 YES
Urology 3_8 YES
Urology 4_1 YES
Urology 4_2 YES
Urology 4_3 YES
Urology 4_4 YES
Urology 4_5 YES
Urology 4_6 YES
Urology 4_7 YES
Urology 4_8 YES
Urology 4_9 YES
Urology 5_1 YES
Urology 5_2 YES
Urology 5_3 YES
Urology 5_4 YES
Urology 5_5 YES
Urology 5_6 YES
Urology 5_7 YES
Urology 5_9 YES
Urology 6_1 YES
Urology 6_2 YES
Urology 6_3 YES
Urology 6_4 YES
Urology 6_5 YES
Urology 6_6 YES
Urology 6_7 YES
Urology 6_8 YES
Urology 6_9 YES
Urology 8_4 YES
Urology 8_7 YES
Urology 9_1 YES
Urology 9_4 YES
Urology 9_5 YES
Urology 9_6 YES
Urology 9_7 YES
Urology 9_8 YES
Urology 10_1 YES
Urology 10_2 YES
Urology 10_3 YES
Urology 10_4 YES
Urology 10_5 YES
Urology 10_6 YES
Urology 10_7 YES
Urology 10_8 YES
Urology 11_1 YES
Urology 11_2 YES
Urology 11_3 YES
Urology 11_4 YES
Urology 11_5 YES
Urology 11_6 YES
Urology 11_8 YES
Urology 12_1 YES
Urology 12_2 YES
Urology 12_3 YES
Urology 12_4 YES
Urology 12_5 YES
Urology 12_6 YES
Urology 12_7 YES
Urology 12_8 YES
Urology 12_9 YES
Urology 13_1 YES
Urology 13_2 YES
Urology 13_3 YES
Urology 13_4 YES
Urology 13_5 YES
Urology 13_6 YES
Urology 13_7 YES
Urology 13_8 YES
Urology 13_9 YES
Urology 14_1 YES
Urology 14_2 YES
Urology 14_3 YES
Urology 14_4 YES
Urology 14_5 YES
Urology 14_6 YES
Urology 14_7 YES
Urology 14_8 YES
Urology 14_9 YES
Urology 2_13 YES
Urology 4_11 YES
Urology 4_12 YES
Urology 4_13 YES
Urology 4_14 YES
Urology 4_15 YES
Urology 4_16 YES
Urology 4_18 YES
Urology 12_11 YES
Urology 12_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):
specialty POPracticeUnitCode Cnt percentInPlace
Cardiology B00000002437 36 32.7
Cardiology B00000002471 35 31.8
Cardiology B00000000362 55 50
Cardiology B00000002532 40 36.4
Cardiology B00000000371 35 31.8
Cardiology B00000000372 39 35.5
Cardiology B00000000442 36 32.7
Cardiology B00000002566 42 38.2
Cardiology B00000020698 42 38.2
Cardiology B00000000589 76 69.1
Cardiology B00000027301 68 61.8
Cardiology B00000000845 46 41.8
Cardiology B00000003415 38 34.5
Cardiology B00000003485 67 60.9
Cardiology B00000001405 23 20.9
Cardiology B00000002906 17 15.5
Cardiology B00000027311 74 67.3
Cardiology B00000003670 23 20.9
Cardiology B00000002319 87 79.1
Post #1544342
Posted Monday, February 24, 2014 4:21 AM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
-- 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',
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'
AND capforthisspecialty = 'YES'
AND capnumber IN ('1_1','1_2') -- etc



“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1544432
Posted Monday, February 24, 2014 4:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 57, Visits: 375
Thanks for your answer Chris. I very much appreciate the time you took to read my examples and write up a solution.

The reason I have the square brackets is that I get an error if I call a column, say, 1_1. The table named winter_2014uto contains columns named [1_1]....[14_10] with "yes" or "no" for each value of practice. I have to see how many are yes for each row (practice). I will try again without the square brackets to see if I got a mistaken impression about that at some point.

I will add my code after all the union alls back in and report back on my findings...

Thanks again!
Post #1544438
Posted Monday, February 24, 2014 4:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
pharmkittie (2/24/2014)
Thanks for your answer Chris. I very much appreciate the time you took to read my examples and write up a solution.


No worries. No solution yet though, we're still working on defining the problem

I may have missed something but how is that I can cut out all the 1400+ lines that specify each capability (the [1_1,[1_2]...,[5_5],[5_8]....)? Each specialty has a different, unpredictable and discontinuous set of capabilities that must be achieved. There are sometimes about 115 or so of these but some have fewer.


SELECT something
FROM sometables
WHERE c.specialty = 'Cardiology'
and [1_1] = 'YES'
AND capforthisspecialty = 'YES'
AND capnumber = '1_1'
UNION ALL
SELECT something
FROM sometables
WHERE c.specialty = 'Cardiology'
and [1_1] = 'YES'
AND capforthisspecialty = 'YES'
AND capnumber = '1_2'
UNION ALL
SELECT something
FROM sometables
WHERE c.specialty = 'Cardiology'
and [1_1] = 'YES'
AND capforthisspecialty = 'YES'
AND capnumber = '1_3'


is the same as
  
SELECT something
FROM sometables
WHERE c.specialty = 'Cardiology'
and [1_1] = 'YES'
AND capforthisspecialty = 'YES'
AND capnumber IN ('1_1','1_2','1_3')



The reason I have the square brackets is that I get an error if I call a column, say, 1_1.
I understand that - what about the regular () brackets?

The table named winter_2014uto contains columns named [1_1]....[14_10] with "yes" or "no" for each value of practice. I have to see how many are yes for each row (practice).

Can I really eliminate all the unioned queries from [1_1]...[14_10] (discontinuous) except those you've left in?

I think so. Just use the IN () as above.


I have a separate script for each specialty. I have just shown Cardiology. So you can imagine the likelihood of me making an error if I copied, pasted, and adjusted to make sure I have the right combination of capabilities.

Thanks again!


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1544441
Posted Monday, February 24, 2014 4:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 57, Visits: 375
Hello it's the OP again. I ran the query that you suggested Chris after adding the bottom part of my code and uncommenting the first "into #temp1". It gave me the same results are what I had after doing my incredibly long and laborious original 1500+ line version with c. 110 union alls. Thank you SO much. You've saved me so much work when I do this for the other specialties (I'd done 3 so far and had many more to go).

You rock.

Also, I am continuing to look at your other suggestions like using cast instead of my convert...still discovering more goodness in your reply.
Post #1544444
Posted Monday, February 24, 2014 6:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
You're welcome - and it's great to hear that you are benefiting so much from visiting ssc

“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1544464
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse