Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Convert the following sql server.

Author  Topic 

macupryk
Starting Member

9 Posts

Posted - 2013-05-12 : 13:48:08
I need to setup the following in some table in sql.
How should I setup my tables.
<code>
CREATE TABLE Career_Category
(
category_id char(2),
category_title varchar(255)
)

CREATE TABLE Career
(
career_id char(10),
career_title varchar(255),
category_id char(2)
)

GO

<script language="JavaScript" type="text/JavaScript"><!--
var oCareersData = new Object
var tmp1 = new Object
tmp1["category_title"] = "Management"
var tmp2 = new Object
tmp2["11-1011.00"] = "Chief Executives"
tmp2["11-1021.00"] = "General & Operations Managers"
tmp2["11-1031.00"] = "Legislators"
tmp2["11-2011.00"] = "Advertising & Promotions Managers"
tmp2["11-2021.00"] = "Marketing Managers"
tmp2["11-2022.00"] = "Sales Managers"
tmp2["11-2031.00"] = "Public Relations Managers"
tmp2["11-3011.00"] = "Administrative Services Managers"
tmp2["11-3021.00"] = "Computer & Information Systems Managers"
tmp2["11-3031.01"] = "Treasurers & Controllers"
tmp2["11-3031.02"] = "Financial Managers, Branch or Department"
tmp2["11-3040.00"] = "Human Resources Managers"
tmp2["11-3041.00"] = "Compensation & Benefits Managers"
tmp2["11-3042.00"] = "Training & Development Managers"
tmp2["11-3049.99"] = "Human Resources Managers, Other"
tmp2["11-3051.00"] = "Industrial Production Managers"
tmp2["11-3061.00"] = "Purchasing Managers"
tmp2["11-3071.01"] = "Transportation Managers"
tmp2["11-3071.02"] = "Storage & Distribution Managers"
tmp2["11-9011.01"] = "Nursery & Greenhouse Managers"
tmp2["11-9011.02"] = "Crop & Livestock Managers"
tmp2["11-9011.03"] = "Aquacultural Managers"
tmp2["11-9012.00"] = "Farmers & Ranchers"
tmp2["11-9021.00"] = "Construction Managers"
tmp2["11-9031.00"] = "Education Administrators - Preschool & Child Care Centers"
tmp2["11-9032.00"] = "Education Administrators - Elementary & High School"
tmp2["11-9033.00"] = "Education Administrators - College"
tmp2["11-9039.99"] = "Education Administrators, Other"
tmp2["11-9041.00"] = "Engineering Managers"
tmp2["11-9051.00"] = "Food Service Managers"
tmp2["11-9061.00"] = "Funeral Directors"
tmp2["11-9071.00"] = "Gaming Managers"
tmp2["11-9081.00"] = "Lodging Managers"
tmp2["11-9111.00"] = "Medical & Health Services Managers"
tmp2["11-9121.00"] = "Natural Sciences Managers"
tmp2["11-9131.00"] = "Postmasters & Mail Superintendents"
tmp2["11-9141.00"] = "Property, Real Estate & Community Association Managers"
tmp2["11-9151.00"] = "Social & Community Service Managers"
tmp2["11-9199.99"] = "Managers, Other"
tmp1["careers"] = tmp2
tmp2 = null
oCareersData["11"] = tmp1
tmp1 = null
var tmp2 = new Object
tmp2["category_title"] = "Business & Financial Operations"
var tmp3 = new Object
tmp3["13-1011.00"] = "Agents & Business Managers of Artists, Performers & Athletes"
tmp3["13-1021.00"] = "Purchasing Agents & Buyers - Farm Products"
tmp3["13-1022.00"] = "Wholesale & Retail Buyers"
tmp3["13-1023.00"] = "Purchasing Agents"
tmp3["13-1031.01"] = "Claims Examiners - Property & Casualty Insurance"
tmp3["13-1031.02"] = "Insurance Adjusters - Examiners & Investigators"
tmp3["13-1032.00"] = "Insurance Appraisers - Auto Damage"
tmp3["13-1041.01"] = "Environmental Compliance Inspectors"
tmp3["13-1041.02"] = "Licensing Examiners & Inspectors"
tmp3["13-1041.03"] = "Equal Opportunity Representatives & Officers"
tmp3["13-1041.04"] = "Government Property Inspectors & Investigators"
tmp3["13-1041.06"] = "Coroners"
tmp3["13-1051.00"] = "Cost Estimators"
tmp3["13-1061.00"] = "Emergency Management Specialists"
tmp3["13-1071.01"] = "Employment Interviewers"
tmp3["13-1071.02"] = "Personnel Recruiters"
tmp3["13-1072.00"] = "Compensation, Benefits & Job Analysis Specialists"
tmp3["13-1073.00"] = "Training & Development Specialists"
tmp3["13-1079.99"] = "Human Resource Specialists, Other"
tmp3["13-1081.00"] = "Logisticians"
tmp3["13-1111.00"] = "Management Analysts"
tmp3["13-1121.00"] = "Meeting & Convention Planners"
tmp3["13-1199.99"] = "Business Operations Specialists, Other"
tmp3["13-2011.01"] = "Accountants"
tmp3["13-2011.02"] = "Auditors"
tmp3["13-2021.01"] = "Assessors"
tmp3["13-2021.02"] = "Appraisers - Real Estate"
tmp3["13-2031.00"] = "Budget Analysts"
tmp3["13-2041.00"] = "Credit Analysts"
tmp3["13-2051.00"] = "Financial Analysts"
tmp3["13-2052.00"] = "Personal Financial Advisors"
tmp3["13-2053.00"] = "Insurance Underwriters"
tmp3["13-2061.00"] = "Financial Examiners"
tmp3["13-2071.00"] = "Loan Counselors"
tmp3["13-2072.00"] = "Loan Officers & Mortgage Brokers"
tmp3["13-2081.00"] = "Tax Examiners, Collectors & Revenue Agents"
tmp3["13-2082.00"] = "Tax Preparers"
tmp3["13-2099.99"] = "Financial Specialists, Other"
tmp2["careers"] = tmp3
tmp3 = null
oCareersData["13"] = tmp2
tmp2 = null
var tmp3 = new Object
tmp3["category_title"] = "Computer & Mathematical"
var tmp4 = new Object
tmp4["15-1011.00"] = "Computer & Information Scientists - Research"
tmp4["15-1021.00"] = "Computer Programmers"
tmp4["15-1031.00"] = "Computer Software Engineers - Applications"
tmp4["15-1032.00"] = "Computer Software Engineers - Systems Software"
tmp4["15-1041.00"] = "Computer Support Specialists"
tmp4["15-1051.00"] = "Computer Systems Analysts"
tmp4["15-1061.00"] = "Database Administrators"
tmp4["15-1071.00"] = "Network & Computer Systems Administrators"
tmp4["15-1071.01"] = "Computer Security Specialists"
tmp4["15-1081.00"] = "Network Systems & Data Communications Analysts"
tmp4["15-1099.01"] = "Software Quality Assurance Engineers & Testers"
tmp4["15-1099.02"] = "Computer Systems Engineers/Architects"
tmp4["15-1099.03"] = "Network Designers"
tmp4["15-1099.04"] = "Web Developers"
tmp4["15-1099.05"] = "Web Administrators"
tmp4["15-1099.99"] = "Computer Specialists, Other"
tmp4["15-2011.00"] = "Actuaries"
tmp4["15-2021.00"] = "Mathematicians"
tmp4["15-2031.00"] = "Operations Research Analysts"
tmp4["15-2041.00"] = "Statisticians"
tmp4["15-2091.00"] = "Mathematical Technicians"
tmp4["15-2099.99"] = "Mathematical Science Occupations, Other"
tmp3["careers"] = tmp4
tmp4 = null
oCareersData["15"] = tmp3
tmp3 = null
var tmp4 = new Object
tmp4["category_title"] = "Engineering & Architecture"
var tmp5 = new Object
tmp5["17-1011.00"] = "Architects"
tmp5["17-1012.00"] = "Landscape Architects"
tmp5["17-1021.00"] = "Cartographers & Photogrammetrists"
tmp5["17-1022.00"] = "Surveyors"
tmp5["17-2011.00"] = "Aerospace Engineers"
tmp5["17-2021.00"] = "Agricultural Engineers"
tmp5["17-2031.00"] = "Biomedical Engineers"
tmp5["17-2041.00"] = "Chemical Engineers"
tmp5["17-2051.00"] = "Civil Engineers"
tmp5["17-2061.00"] = "Computer Hardware Engineers"
tmp5["17-2071.00"] = "Electrical Engineers"
tmp5["17-2072.00"] = "Electronics Engineers"
tmp5["17-2081.00"] = "Environmental Engineers"
tmp5["17-2111.01"] = "Industrial Safety & Health Engineers"
tmp5["17-2111.02"] = "Fire-Prevention & Protection Engineers"
tmp5["17-2111.03"] = "Product Safety Engineers"
tmp5["17-2112.00"] = "Industrial Engineers"
tmp5["17-2121.01"] = "Marine Engineers"
tmp5["17-2121.02"] = "Marine Architects"
tmp5["17-2131.00"] = "Materials Engineers"
tmp5["17-2141.00"] = "Mechanical Engineers"
tmp5["17-2151.00"] = "Mining & Geological Engineers"
tmp5["17-2161.00"] = "Nuclear Engineers"
tmp5["17-2171.00"] = "Petroleum Engineers"
tmp5["17-2199.99"] = "Engineers, Other"
tmp5["17-3011.01"] = "Architectural Drafters"
tmp5["17-3011.02"] = "Civil Drafters"
tmp5["17-3012.01"] = "Electronic Drafters"
tmp5["17-3012.02"] = "Electrical Drafters"
tmp5["17-3013.00"] = "Mechanical Drafters"
tmp5["17-3019.99"] = "Drafters, Other"
tmp5["17-3021.00"] = "Aerospace Engineering & Operations Technicians"
tmp5["17-3022.00"] = "Civil Engineering Technicians"
tmp5["17-3023.01"] = "Electronics Engineering Technicians"
tmp5["17-3023.03"] = "Electrical Engineering Technicians"
tmp5["17-3024.00"] = "Electro-Mechanical Technicians"
tmp5["17-3025.00"] = "Environmental Engineering Technicians"
tmp5["17-3026.00"] = "Industrial Engineering Technicians"
tmp5["17-3027.00"] = "Mechanical Engineering Technicians"
tmp5["17-3029.99"] = "Engineering Technicians, Other"
tmp5["17-3031.01"] = "Surveying Technicians"
tmp5["17-3031.02"] = "Mapping Technicians"
tmp4["careers"] = tmp5
tmp5 = null
oCareersData["17"] = tmp4
tmp4 = null
var tmp5 = new Object
tmp5["category_title"] = "Life, Physical, & Social Sciences"
var tmp6 = new Object
tmp6["19-1011.00"] = "Animal Scientists"
tmp6["19-1012.00"] = "Food Scientists & Technologists"
tmp6["19-1013.00"] = "Soil & Plant Scientists"
tmp6["19-1020.01"] = "Biologists"
tmp6["19-1021.00"] = "Biochemists & Biophysicists"
tmp6["19-1022.00"] = "Microbiologists"
tmp6["19-1023.00"] = "Zoologists & Wildlife Biologists"
tmp6["19-1029.99"] = "Biological Scientists, Other"
tmp6["19-1031.01"] = "Soil & Water Conservationists"
tmp6["19-1031.02"] = "Range Managers"
tmp6["19-1031.03"] = "Park Naturalists"
tmp6["19-1032.00"] = "Foresters"
tmp6["19-1041.00"] = "Epidemiologists"
tmp6["19-1042.00"] = "Medical Scientists"
tmp6["19-1099.99"] = "Life Scientists, Other"
tmp6["19-2011.00"] = "Astronomers"
tmp6["19-2012.00"] = "Physicists"
tmp6["19-2021.00"] = "Atmospheric & Space Scientists"
tmp6["19-2031.00"] = "Chemists"
tmp6["19-2032.00"] = "Materials Scientists"
tmp6["19-2041.00"] = "Environmental Scientists & Specialists"
tmp6["19-2042.00"] = "Geologists & Geoscientists"
tmp6["19-2043.00"] = "Hydrologists"
tmp6["19-2099.99"] = "Physical Scientists, Other"
tmp6["19-3011.00"] = "Economists"
tmp6["19-3021.00"] = "Market Research Analysts"
tmp6["19-3022.00"] = "Survey Researchers"
tmp6["19-3031.01"] = "School Psychologists"
tmp6["19-3031.02"] = "Clinical Psychologists"
tmp6["19-3031.03"] = "Counseling Psychologists"
tmp6["19-3032.00"] = "Industrial-Organizational Psychologists"
tmp6["19-3039.99"] = "Psychologists, Other"
tmp6["19-3041.00"] = "Sociologists"
tmp6["19-3051.00"] = "Urban & Regional Planners"
tmp6["19-3091.01"] = "Anthropologists"
tmp6["19-3091.02"] = "Archeologists"
tmp6["19-3092.00"] = "Geographers"
tmp6["19-3093.00"] = "Historians"
tmp6["19-3094.00"] = "Political Scientists"
tmp6["19-3099.99"] = "Social Scientists, Other"
tmp6["19-4011.01"] = "Agricultural Technicians"
tmp6["19-4011.02"] = "Food Science Technicians"
tmp6["19-4021.00"] = "Biological Technicians"
tmp6["19-4031.00"] = "Chemical Technicians"
tmp6["19-4041.01"] = "Geophysical Data Technicians"
tmp6["19-4041.02"] = "Geological Sample Test Technicians"
tmp6["19-4051.01"] = "Nuclear Equipment Operation Technicians"
tmp6["19-4051.02"] = "Nuclear Monitoring Technicians"
tmp6["19-4061.00"] = "Social Science Research Assistants"
tmp6["19-4061.01"] = "City Planning Aides"
tmp6["19-4091.00"] = "Environmental Science & Protection Technicians"
tmp6["19-4092.00"] = "Forensic Science Technicians"
tmp6["19-4093.00"] = "Forest & Conservation Technicians"
tmp6["19-4099.99"] = "Life, Physical & Social Science Technicians, Other"
tmp5["careers"] = tmp6
tmp6 = null
oCareersData["19"] = tmp5
tmp5 = null
var tmp6 = new Object
tmp6["category_title"] = "Counseling, Community & Social Services"
var tmp7 = new Object
tmp7["21-1011.00"] = "Substance Abuse & Behavioral Disorder Counselors"
tmp7["21-1012.00"] = "Educational, Vocational & School Counselors"
tmp7["21-1013.00"] = "Marriage & Family Therapists"
tmp7["21-1014.00"] = "Mental Health Counselors"
tmp7["21-1015.00"] = "Rehabilitation Counselors"
tmp7["21-1019.99"] = "Counselors, Other"
tmp7["21-1021.00"] = "Child, Family & School Social Workers"
tmp7["21-1022.00"] = "Medical & Public Health Social Workers"
tmp7["21-1023.00"] = "Mental Health & Substance Abuse Social Workers"
tmp7["21-1029.99"] = "Social Workers, Other"
tmp7["21-1091.00"] = "Health Educators"
tmp7["21-1092.00"] = "Probation Officers & Correctional Treatment Specialists"
tmp7["21-1093.00"] = "Social & Human Service Assistants"
tmp7["21-1099.99"] = "Community & Social Service Specialists, Other"
tmp7["21-2011.00"] = "Clergy"
tmp7["21-2021.00"] = "Directors - Religious Activities & Education"
tmp7["21-2099.99"] = "Religious Workers, Other"
tmp6["careers"] = tmp7
tmp7 = null
oCareersData["21"] = tmp6
tmp6 = null
var tmp7 = new Object
tmp7["category_title"] = "Legal"
var tmp8 = new Object
tmp8["23-1011.00"] = "Lawyers"
tmp8["23-1021.00"] = "Administrative Law Judges, Adjudicators & Hearing Officers"
tmp8["23-1022.00"] = "Arbitrators, Mediators & Conciliators"
tmp8["23-1023.00"] = "Judges, Magistrate Judges & Magistrates"
tmp8["23-2011.00"] = "Paralegals & Legal Assistants"
tmp8["23-2091.00"] = "Court Reporters"
tmp8["23-2092.00"] = "Law Clerks"
tmp8["23-2093.00"] = "Title Examiners, Abstractors & Searchers"
tmp8["23-2099.99"] = "Legal Support Workers, Other"
tmp7["careers"] = tmp8
tmp8 = null
oCareersData["23"] = tmp7
tmp7 = null
var tmp8 = new Object
tmp8["category_title"] = "Education, Training, & Library"
var tmp9 = new Object
tmp9["25-1011.00"] = "College Professors - Business"
tmp9["25-1021.00"] = "College Professors - Computer Science"
tmp9["25-1022.00"] = "College Professors - Mathematical Science"
tmp9["25-1031.00"] = "College Professors - Architecture"
tmp9["25-1032.00"] = "College Professors - Engineering"
tmp9["25-1041.00"] = "College Professors - Agricultural Sciences"
tmp9["25-1042.00"] = "College Professors - Biological Science"
tmp9["25-1043.00"] = "College Professors - Forestry & Conservation Science"
tmp9["25-1051.00"] = "College Professors - Atmospheric, Earth, Marine, & Space Science"
tmp9["25-1052.00"] = "College Professors - Chemistry"
tmp9["25-1053.00"] = "College Professors - Environmental Science"
tmp9["25-1054.00"] = "College Professors - Physics"
tmp9["25-1061.00"] = "College Professors - Anthropology & Archeology"
tmp9["25-1062.00"] = "College Professors - Area, Ethnic & Cultural Studies"
tmp9["25-1063.00"] = "College Professors - Economics"
tmp9["25-1064.00"] = "College Professors - Geography"
tmp9["25-1065.00"] = "College Professors - Political Science"
tmp9["25-1066.00"] = "College Professors - Psychology"
tmp9["25-1067.00"] = "College Professors - Sociology"
tmp9["25-1069.99"] = "College Professors - Other Social Sciences"
tmp9["25-1071.00"] = "College Instructors - Medicine & Health Specialties"
tmp9["25-1072.00"] = "College Instructors - Nursing"
tmp9["25-1081.00"] = "College Instructors - Education"
tmp9["25-1082.00"] = "College Instructors - Library Science"
tmp9["25-1111.00"] = "College Instructors - Criminal Justice & Law Enforcement"
tmp9["25-1112.00"] = "College Professors - Law"
tmp9["25-1113.00"] = "College Instructors - Social Work"
tmp9["25-1121.00"] = "College Professors - Art, Drama & Music Teachers"
tmp9["25-1122.00"] = "College Professors - Communications"
tmp9["25-1123.00"] = "College Professors - English Language & Literature"
tmp9["25-1124.00"] = "College Professors - Foreign Language & Literature"
tmp9["25-1125.00"] = "College Professors - History"
tmp9["25-1126.00"] = "College Professors - Philosophy & Religion"
tmp9["25-1191.00"] = "Graduate Teaching Assistants"
tmp9["25-1192.00"] = "College Instructors - Home Economics"
tmp9["25-1193.00"] = "College Instructors - Recreation & Fitness Studies"
tmp9["25-1194.00"] = "College Instructors - Vocational Studies"
tmp9["25-1199.99"] = "College Instructors - Other"
tmp9["25-2011.00"] = "Preschool Teachers"
tmp9["25-2012.00"] = "Kindergarten Teachers"
tmp9["25-2021.00"] = "Elementary School Teachers"
tmp9["25-2022.00"] = "Middle School Teachers"
tmp9["25-2023.00"] = "Middle School Teachers - Vocational Studies"
tmp9["25-2031.00"] = "High School Teachers"
tmp9["25-2032.00"] = "High School Teachers - Vocational Studies"
tmp9["25-2041.00"] = "Preschool & Elementary School Teachers - Special Education"
tmp9["25-2042.00"] = "Middle School Teachers - Special Education"
tmp9["25-2043.00"] = "High School Teachers - Special Education"
tmp9["25-3011.00"] = "Adult Literacy, Remedial Education & GED Teachers"
tmp9["25-3021.00"] = "Self-Enrichment Education Teachers"
tmp9["25-3099.99"] = "Teachers & Instructors, Other"
tmp9["25-4011.00"] = "Archivists"
tmp9["25-4012.00"] = "Curators"
tmp9["25-4013.00"] = "Museum Technicians & Conservators"
tmp9["25-4021.00"] = "Librarians"
tmp9["25-4031.00"] = "Library Technicians"
tmp9["25-9011.00"] = "Audio-Visual Collections Specialists"
tmp9["25-9021.00"] = "Farm & Home Management Advisors"
tmp9["25-9031.00"] = "Instructional Coordinators"
tmp9["25-9041.00"] = "Teaching Assistants"
tmp9["25-9099.99"] = "Education, Training & Library Workers, Other"
tmp8["careers"] = tmp9
tmp9 = null
oCareersData["25"] = tmp8
tmp8 = null
var tmp9 = new Object
tmp9["category_title"] = "Arts, Design, Entertainment, Sports, & Media"
var tmp10 = new Object
tmp10["27-1011.00"] = "Art Directors"
tmp10["27-1012.00"] = "Craft Artists"
tmp10["27-1013.00"] = "Fine Artists - Painters, Sculptors & Illustrators"
tmp10["27-1014.00"] = "Multi-Media Artists & Animators"
tmp10["27-1019.99"] = "Artists and Related Workers, Other"
tmp10["27-1021.00"] = "Commercial & Industrial Designers"
tmp10["27-1022.00"] = "Fashion Designers"
tmp10["27-1023.00"] = "Floral Designers"
tmp10["27-1024.00"] = "Graphic Designers"
tmp10["27-1025.00"] = "Interior Designers"
tmp10["27-1026.00"] = "Merchandise Displayers & Window Trimmers"
tmp10["27-1027.00"] = "Set & Exhibit Designers"
tmp10["27-1029.99"] = "Designers, Other"
tmp10["27-2011.00"] = "Actors"
tmp10["27-2012.01"] = "Producers"
tmp10["27-2012.02"] = "Directors - Stage, Film, Television & Radio"
tmp10["27-2012.03"] = "Program Directors"
tmp10["27-2012.04"] = "Talent Directors"
tmp10["27-2012.05"] = "Technical Directors & Production Managers"
tmp10["27-2021.00"] = "Athletes & Sports Competitors"
tmp10["27-2022.00"] = "Coaches & Scouts"
tmp10["27-2023.00"] = "Umpires, Referees & Other Sports Officials"
tmp10["27-2031.00"] = "Dancers"
tmp10["27-2032.00"] = "Choreographers"
tmp10["27-2041.01"] = "Music Directors"
tmp10["27-2041.04"] = "Music Composers & Arrangers"
tmp10["27-2042.01"] = "Singers"
tmp10["27-2042.02"] = "Musicians"
tmp10["27-2099.99"] = "Entertainment, Performance, or Sports Workers, Other"
tmp10["27-3011.00"] = "Radio & Television Announcers"
tmp10["27-3012.00"] = "Public Address System & Other Announcers"
tmp10["27-3021.00"] = "Broadcast News Analysts"
tmp10["27-3022.00"] = "Reporters & Correspondents"
tmp10["27-3031.00"] = "Public Relations Specialists"
tmp10["27-3041.00"] = "Editors"
tmp10["27-3042.00"] = "Technical Writers"
tmp10["27-3043.04"] = "Copy Writers"
tmp10["27-3043.05"] = "Creative Writers - Authors, Poets & Lyricists"
tmp10["27-3091.00"] = "Interpreters & Translators"
tmp10["27-3099.99"] = "Media & Communication Workers, Other"
tmp10["27-4011.00"] = "Audio & Video Equipment Technicians"
tmp10["27-4012.00"] = "Broadcast Technicians"
tmp10["27-4013.00"] = "Radio Operators"
tmp10["27-4014.00"] = "Sound Engineering Technicians"
tmp10["27-4021.00"] = "Photographers"
tmp10["27-4031.00"] = "Camera Operators - Television, Video & Motion Picture"
tmp10["27-4032.00"] = "Film & Video Editors"
tmp10["27-4099.99"] = "Media & Communication Equipment Workers, Other"
tmp9["careers"] = tmp10
tmp10 = null
oCareersData["27"] = tmp9
tmp9 = null
var tmp10 = new Object
tmp10["category_title"] = "Healthcare Practitioners & Technical"
var tmp11 = new Object
tmp11["29-1011.00"] = "Chiropractors"
tmp11["29-1021.00"] = "Dentists - General"
tmp11["29-1022.00"] = "Oral & Maxillofacial Surgeons"
tmp11["29-1023.00"] = "Orthodontists"
tmp11["29-1024.00"] = "Prosthodontists"
tmp11["29-1029.99"] = "Dentists, Other Specialties"
tmp11["29-1031.00"] = "Dietitians & Nutritionists"
tmp11["29-1041.00"] = "Optometrists"
tmp11["29-1051.00"] = "Pharmacists"
tmp11["29-1061.00"] = "Anesthesiologists"
tmp11["29-1062.00"] = "Family & General Practitioners"
tmp11["29-1063.00"] = "Internists - General"
tmp11["29-1064.00"] = "Obstetricians & Gynecologists"
tmp11["29-1065.00"] = "Pediatricians - General"
tmp11["29-1066.00"] = "Psychiatrists"
tmp11["29-1067.00"] = "Surgeons"
tmp11["29-1069.99"] = "Physicians & Surgeons, Other"
tmp11["29-1071.00"] = "Physician Assistants"
tmp11["29-1081.00"] = "Podiatrists"
tmp11["29-1111.00"] = "Registered Nurses"
tmp11["29-1121.00"] = "Audiologists"
tmp11["29-1122.00"] = "Occupational Therapists"
tmp11["29-1123.00"] = "Physical Therapists"
tmp11["29-1124.00"] = "Radiation Therapists"
tmp11["29-1125.00"] = "Recreational Therapists"
tmp11["29-1126.00"] = "Respiratory Therapists"
tmp11["29-1127.00"] = "Speech-Language Pathologists"
tmp11["29-1129.99"] = "Therapists, Other"
tmp11["29-1131.00"] = "Veterinarians"
tmp11["29-1199.99"] = "Health Diagnosing & Treating Practitioners, Other"
tmp11["29-2011.00"] = "Medical & Clinical Laboratory Technologists"
tmp11["29-2012.00"] = "Medical & Clinical Laboratory Technicians"
tmp11["29-2021.00"] = "Dental Hygienists"
tmp11["29-2031.00"] = "Cardiovascular Technologists & Technicians"
tmp11["29-2032.00"] = "Diagnostic Medical Sonographers"
tmp11["29-2033.00"] = "Nuclear Medicine Technologists"
tmp11["29-2034.01"] = "Radiologic Technologists"
tmp11["29-2034.02"] = "Radiologic Technicians"
tmp11["29-2041.00"] = "Emergency Medical Technicians (EMT) & Paramedics"
tmp11["29-2051.00"] = "Dietetic Technicians"
tmp11["29-2052.00"] = "Pharmacy Technicians"
tmp11["29-2053.00"] = "Psychiatric Technicians"
tmp11["29-2054.00"] = "Respiratory Therapy Technicians"
tmp11["29-2055.00"] = "Surgical Technologists"
tmp11["29-2056.00"] = "Veterinary Technologists & Technicians"
tmp11["29-2061.00"] = "Licensed Practical & Licensed Vocational Nurses"
tmp11["29-2071.00"] = "Medical Records & Health Information Technicians"
tmp11["29-2081.00"] = "Opticians - Dispensing"
tmp11["29-2091.00"] = "Orthotists & Prosthetists"
tmp11["29-2099.99"] = "Health Technologists & Technicians, Other"
tmp11["29-9011.00"] = "Occupational Health & Safety Specialists"
tmp11["29-9012.00"] = "Occupational Health & Safety Technicians"
tmp11["29-9091.00"] = "Athletic Trainers"
tmp11["29-9099.99"] = "Healthcare Practitioners & Technical Workers, Other"
tmp10["careers"] = tmp11
tmp11 = null
oCareersData["29"] = tmp10
tmp10 = null
var tmp11 = new Object
tmp11["category_title"] = "Healthcare Support"
var tmp12 = new Object
tmp12["31-1011.00"] = "Home Health Aides"
tmp12["31-1012.00"] = "Nursing Aides, Orderlies & Attendants"
tmp12["31-1013.00"] = "Psychiatric Aides"
tmp12["31-2011.00"] = "Occupational Therapist Assistants"
tmp12["31-2012.00"] = "Occupational Therapist Aides"
tmp12["31-2021.00"] = "Physical Therapist Assistants"
tmp12["31-2022.00"] = "Physical Therapist Aides"
tmp12["31-9011.00"] = "Massage Therapists"
tmp12["31-9091.00"] = "Dental Assistants"
tmp12["31-9092.00"] = "Medical Assistants"
tmp12["31-9093.00"] = "Medical Equipment Preparers"
tmp12["31-9094.00"] = "Medical Transcriptionists"
tmp12["31-9095.00"] = "Pharmacy Aides"
tmp12["31-9096.00"] = "Veterinary Assistants & Laboratory Animal Caretakers"
tmp12["31-9099.99"] = "Healthcare Support Workers, Other"
tmp11["careers"] = tmp12
tmp12 = null
oCareersData["31"] = tmp11
tmp11 = null
var tmp12 = new Object
tmp12["category_title"] = "Protective Service"
var tmp13 = new Object
tmp13["33-1011.00"] = "Managers/Supervisors of Correctional Officers"
tmp13["33-1012.00"] = "Managers/Supervisors of Police & Detectives"
tmp13["33-1021.01"] = "Managers/Supervisors of Municipal Fire Fighters"
tmp13["33-1021.02"] = "Managers/Supervisors of Forest Fire Fighters"
tmp13["33-1099.99"] = "Managers/Supervisors of Other Protective Service Workers"
tmp13["33-2011.01"] = "Municipal Fire Fighters"
tmp13["33-2011.02"] = "Forest Fire Fighters"
tmp13["33-2021.01"] = "Fire Inspectors"
tmp13["33-2021.02"] = "Fire Investigators"
tmp13["33-2022.00"] = "Forest Fire Inspectors & Prevention Specialists"
tmp13["33-3011.00"] = "Bailiffs"
tmp13["33-3012.00"] = "Correctional Officers & Jailers"
tmp13["33-3021.01"] = "Police Detectives"
tmp13["33-3021.02"] = "Police Identification & Records Officers"
tmp13["33-3021.03"] = "Criminal Investigators & Special Agents"
tmp13["33-3021.05"] = "Immigration & Customs Inspectors"
tmp13["33-3031.00"] = "Fish & Game Wardens"
tmp13["33-3041.00"] = "Parking Enforcement Workers"
tmp13["33-3051.01"] = "Police Patrol Officers"
tmp13["33-3051.03"] = "Sheriffs & Deputy Sheriffs"
tmp13["33-3052.00"] = "Transit & Railroad Police"
tmp13["33-9011.00"] = "Animal Control Workers"
tmp13["33-9021.00"] = "Private Detectives & Investigators"
tmp13["33-9031.00"] = "Gaming Surveillance Officers & Gaming Investigators"
tmp13["33-9032.00"] = "Security Guards"
tmp13["33-9091.00"] = "Crossing Guards"
tmp13["33-9092.00"] = "Lifeguards, Ski Patrol & Recreational Protective Service"
tmp13["33-9099.01"] = "Transportation Security Screeners"
tmp13["33-9099.99"] = "Protective Service Workers, Other"
tmp12["careers"] = tmp13
tmp13 = null
oCareersData["33"] = tmp12
tmp12 = null
var tmp13 = new Object
tmp13["category_title"] = "Food Preparation & Service"
var tmp14 = new Object
tmp14["35-1011.00"] = "Chefs & Head Cooks"
tmp14["35-1012.00"] = "Managers of Food Preparation & Serving Workers"
tmp14["35-2011.00"] = "Cooks - Fast Food"
tmp14["35-2012.00"] = "Cooks - Institution & Cafeteria"
tmp14["35-2013.00"] = "Cooks - Private Household"
tmp14["35-2014.00"] = "Cooks - Restaurant"
tmp14["35-2015.00"] = "Cooks - Short Order"
tmp14["35-2019.99"] = "Cooks - Other"
tmp14["35-2021.00"] = "Food Preparation Workers"
tmp14["35-3011.00"] = "Bartenders"
tmp14["35-3021.00"] = "Food Preparation & Serving Workers (including fast food)"
tmp14["35-3022.00"] = "Counter Attendants - Cafeteria & Coffee Shop"
tmp14["35-3031.00"] = "Waiters & Waitresses"
tmp14["35-3041.00"] = "Food Servers - Nonrestaurant"
tmp14["35-9011.00"] = "Dining Room & Cafeteria Attendants & Bartender Helpers"
tmp14["35-9021.00"] = "Dishwashers"
tmp14["35-9031.00"] = "Hosts & Hostesses - Restaurant, Lounge & Coffee Shop"
tmp14["35-9099.99"] = "Food Preparation & Serving Workers, Other"
tmp13["careers"] = tmp14
tmp14 = null
oCareersData["35"] = tmp13
tmp13 = null
var tmp14 = new Object
tmp14["category_title"] = "Building and Grounds Cleaning & Maintenance"
var tmp15 = new Object
tmp15["37-1011.00"] = "Managers/Supervisors of Housekeeping & Janitorial Workers"
tmp15["37-1012.00"] = "Managers/Supervisors of Landscaping & Groundskeeping Workers"
tmp15["37-2011.00"] = "Janitors & Cleaners"
tmp15["37-2012.00"] = "Maids & Housekeeping Cleaners"
tmp15["37-2019.99"] = "Building Cleaning Workers, Other"
tmp15["37-2021.00"] = "Pest Control Workers"
tmp15["37-3011.00"] = "Landscaping & Groundskeeping Workers"
tmp15["37-3012.00"] = "Pesticide Handlers, Sprayers & Applicators - Vegetation"
tmp15["37-3013.00"] = "Tree Trimmers & Pruners"
tmp15["37-3019.99"] = "Grounds Maintenance Workers, Other"
tmp14["careers"] = tmp15
tmp15 = null
oCareersData["37"] = tmp14
tmp14 = null
var tmp15 = new Object
tmp15["category_title"] = "Personal Care & Hospitality"
var tmp16 = new Object
tmp16["39-1011.00"] = "Gaming Supervisors"
tmp16["39-1012.00"] = "Slot Key Persons"
tmp16["39-1021.00"] = "Managers of Personal Service Workers"
tmp16["39-2011.00"] = "Animal Trainers"
tmp16["39-2021.00"] = "Nonfarm Animal Caretakers"
tmp16["39-3011.00"] = "Gaming Dealers"
tmp16["39-3012.00"] = "Gaming & Sports Book Writers & Runners"
tmp16["39-3019.99"] = "Gaming Service Workers, Other"
tmp16["39-3021.00"] = "Motion Picture Projectionists"
tmp16["39-3031.00"] = "Ushers, Lobby Attendants & Ticket Takers"
tmp16["39-3091.00"] = "Amusement & Recreation Attendants"
tmp16["39-3092.00"] = "Costume Attendants"
tmp16["39-3093.00"] = "Locker Room, Coatroom & Dressing Room Attendants"
tmp16["39-3099.99"] = "Entertainment Attendants & Related Workers, Other"
tmp16["39-4011.00"] = "Embalmers"
tmp16["39-4021.00"] = "Funeral Attendants"
tmp16["39-5011.00"] = "Barbers"
tmp16["39-5012.00"] = "Hairdressers, Hairstylists & Cosmetologists"
tmp16["39-5091.00"] = "Makeup Artists - Theatrical & Performance"
tmp16["39-5092.00"] = "Manicurists & Pedicurists"
tmp16["39-5093.00"] = "Shampooers"
tmp16["39-5094.00"] = "Skin Care Specialists"
tmp16["39-6011.00"] = "Baggage Porters & Bellhops"
tmp16["39-6012.00"] = "Concierges"
tmp16["39-6021.00"] = "Tour Guides & Escorts"
tmp16["39-6022.00"] = "Travel Guides"
tmp16["39-6031.00"] = "Flight Attendants"
tmp16["39-6032.00"] = "Transportation Attendants (except flight attendants)"
tmp16["39-9011.00"] = "Child Care Workers"
tmp16["39-9011.01"] = "Nannies"
tmp16["39-9021.00"] = "Personal & Home Care Aides"
tmp16["39-9031.00"] = "Fitness Trainers & Aerobics Instructors"
tmp16["39-9032.00"] = "Recreation Workers"
tmp16["39-9041.00"] = "Residential Advisors"
tmp16["39-9099.99"] = "Personal Care & Service Workers, Other"
tmp15["careers"] = tmp16
tmp16 = null
oCareersData["39"] = tmp15
tmp15 = null
var tmp16 = new Object
tmp16["category_title"] = "Sales and Related"
var tmp17 = new Object
tmp17["41-1011.00"] = "Managers of Retail Sales Workers"
tmp17["41-1012.00"] = "Managers of Non-Retail Sales Workers"
tmp17["41-2011.00"] = "Cashiers"
tmp17["41-2012.00"] = "Gaming Change Persons & Booth Cashiers"
tmp17["41-2021.00"] = "Counter & Rental Clerks"
tmp17["41-2022.00"] = "Parts Salespersons"
tmp17["41-2031.00"] = "Retail Salespersons"
tmp17["41-3011.00"] = "Advertising Sales Agents"
tmp17["41-3021.00"] = "Insurance Sales Agents"
tmp17["41-3031.01"] = "Sales Agents - Securities & Commodities"
tmp17["41-3031.02"] = "Sales Agents - Financial Services"
tmp17["41-3041.00"] = "Travel Agents"
tmp17["41-3099.99"] = "Sales Representatives - Other Services"
tmp17["41-4011.00"] = "Sales Representatives - Technical & Scientific Products"
tmp17["41-4012.00"] = "Sales Representatives - Wholesale & Manufacturing"
tmp17["41-9011.00"] = "Demonstrators & Product Promoters"
tmp17["41-9012.00"] = "Models"
tmp17["41-9021.00"] = "Real Estate Brokers"
tmp17["41-9022.00"] = "Real Estate Sales Agents"
tmp17["41-9031.00"] = "Sales Engineers"
tmp17["41-9041.00"] = "Telemarketers"
tmp17["41-9091.00"] = "Door-To-Door Sales Workers, News & Street Vendors"
tmp17["41-9099.99"] = "Sales Workers, Other"
tmp16["careers"] = tmp17
tmp17 = null
oCareersData["41"] = tmp16
tmp16 = null
var tmp17 = new Object
tmp17["category_title"] = "Office and Administrative Support"
var tmp18 = new Object
tmp18["43-1011.00"] = "Managers/Supervisors of Office & Administrative Support Workers"
tmp18["43-2011.00"] = "Switchboard Operators (including answering service)"
tmp18["43-2021.00"] = "Telephone Operators"
tmp18["43-2099.99"] = "Communications Equipment Operators, Other"
tmp18["43-3011.00"] = "Bill & Account Collectors"
tmp18["43-3021.01"] = "Statement Clerks"
tmp18["43-3021.02"] = "Billing, Cost & Rate Clerks"
tmp18["43-3021.03"] = "Billing, Posting & Calculating Machine Operators"
tmp18["43-3031.00"] = "Bookkeeping, Accounting & Auditing Clerks"
tmp18["43-3041.00"] = "Gaming Cage Workers"
tmp18["43-3051.00"] = "Payroll & Timekeeping Clerks"
tmp18["43-3061.00"] = "Procurement Clerks"
tmp18["43-3071.00"] = "Tellers"
tmp18["43-4011.00"] = "Brokerage Clerks"
tmp18["43-4021.00"] = "Correspondence Clerks"
tmp18["43-4031.01"] = "Court Clerks"
tmp18["43-4031.02"] = "Municipal Clerks"
tmp18["43-4031.03"] = "License Clerks"
tmp18["43-4041.01"] = "Credit Authorizers"
tmp18["43-4041.02"] = "Credit Checkers"
tmp18["43-4051.00"] = "Customer Service Representatives"
tmp18["43-4061.00"] = "Eligibility Interviewers - Government Programs"
tmp18["43-4071.00"] = "File Clerks"
tmp18["43-4081.00"] = "Hotel, Motel & Resort Desk Clerks"
tmp18["43-4111.00"] = "Interviewers (except eligibility & loan)"
tmp18["43-4121.00"] = "Library Assistants - Clerical"
tmp18["43-4131.00"] = "Loan Interviewers & Clerks"
tmp18["43-4141.00"] = "New Accounts Clerks"
tmp18["43-4151.00"] = "Order Clerks"
tmp18["43-4161.00"] = "Human Resources Assistants (except payroll & timekeeping)"
tmp18["43-4171.00"] = "Receptionists & Information Clerks"
tmp18["43-4181.00"] = "Reservation/Transportation Ticket Agents & Travel Clerks"
tmp18["43-4199.99"] = "Information & Record Clerks, Other"
tmp18["43-5011.00"] = "Cargo & Freight Agents"
tmp18["43-5021.00"] = "Couriers & Messengers"
tmp18["43-5031.00"] = "Police, Fire & Ambulance Dispatchers"
tmp18["43-5032.00"] = "Dispatchers (except police, fire & ambulance)"
tmp18["43-5041.00"] = "Meter Readers - Utilities"
tmp18["43-5051.00"] = "Postal Service Clerks"
tmp18["43-5052.00"] = "Postal Service Mail Carriers"
tmp18["43-5053.00"] = "Postal Service Mail Sorters & Processors"
tmp18["43-5061.00"] = "Production, Planning & Expediting Clerks"
tmp18["43-5071.00"] = "Shipping, Receiving & Traffic Clerks"
tmp18["43-5081.01"] = "Stock Clerks - Sales Floor"
tmp18["43-5081.02"] = "Marking Clerks"
tmp18["43-5081.03"] = "Stock Clerks - Stockroom, Warehouse or Storage Yard"
tmp18["43-5081.04"] = "Order Fillers - Wholesale & Retail Sales"
tmp18["43-5111.00"] = "Weighers, Measurers, Checkers & Samplers"
tmp18["43-6011.00"] = "Executive Secretaries & Administrative Assistants"
tmp18["43-6012.00"] = "Legal Secretaries"
tmp18["43-6013.00"] = "Medical Secretaries"
tmp18["43-6014.00"] = "Secretaries (except legal, medical & executive)"
tmp18["43-9011.00"] = "Computer Operators"
tmp18["43-9021.00"] = "Data Entry Keyers"
tmp18["43-9022.00"] = "Word Processors & Typists"
tmp18["43-9031.00"] = "Desktop Publishers"
tmp18["43-9041.01"] = "Insurance Claims Clerks"
tmp18["43-9041.02"] = "Insurance Policy Processing Clerks"
tmp18["43-9051.00"] = "Mail Clerks & Mail Machine Operators (except postal service)"
tmp18["43-9061.00"] = "Office Clerks - General"
tmp18["43-9071.00"] = "Office Machine Operators (except computer)"
tmp18["43-9081.00"] = "Proofreaders & Copy Markers"
tmp18["43-9111.00"] = "Statistical Assistants"
tmp18["43-9199.99"] = "Office & Administrative Support Workers, Other"
tmp17["careers"] = tmp18
tmp18 = null
oCareersData["43"] = tmp17
tmp17 = null
var tmp18 = new Object
tmp18["category_title"] = "Farming, Fishing, & Forestry"
var tmp19 = new Object
tmp19["45-1011.05"] = "Managers/Supervisors of Logging Workers"
tmp19["45-1011.06"] = "Managers/Supervisors of Aquacultural Workers"
tmp19["45-1011.07"] = "Managers/Supervisors of Agricultural Crop & Horticultural Workers"
tmp19["45-1011.08"] = "Managers/Supervisors of Animal Husbandry & Animal Care Workers"
tmp19["45-1012.00"] = "Farm Labor Contractors"
tmp19["45-2011.00"] = "Agricultural Inspectors"
tmp19["45-2021.00"] = "Animal Breeders"
tmp19["45-2041.00"] = "Graders & Sorters - Agricultural Products"
tmp19["45-2091.00"] = "Agricultural Equipment Operators"
tmp19["45-2092.01"] = "Nursery Workers"
tmp19["45-2092.02"] = "Farmworkers & Laborers"
tmp19["45-2093.00"] = "Farmworkers - Farm & Ranch Animals"
tmp19["45-2099.99"] = "Agricultural Workers, Other"
tmp19["45-3011.00"] = "Fishers & Related Fishing Workers"
tmp19["45-3021.00"] = "Hunters & Trappers"
tmp19["45-4011.00"] = "Forest & Conservation Workers"
tmp19["45-4021.00"] = "Fallers"
tmp19["45-4022.00"] = "Logging Equipment Operators"
tmp19["45-4023.00"] = "Log Graders & Scalers"
tmp19["45-4029.99"] = "Logging Workers, Other"
tmp18["careers"] = tmp19
tmp19 = null
oCareersData["45"] = tmp18
tmp18 = null
var tmp19 = new Object
tmp19["category_title"] = "Construction & Mining"
var tmp20 = new Object
tmp20["47-1011.00"] = "Managers/Supervisors of Construction & Extraction Workers"
tmp20["47-2011.00"] = "Boilermakers"
tmp20["47-2021.00"] = "Brickmasons & Blockmasons"
tmp20["47-2022.00"] = "Stonemasons"
tmp20["47-2031.01"] = "Construction Carpenters"
tmp20["47-2031.02"] = "Rough Carpenters"
tmp20["47-2041.00"] = "Carpet Installers"
tmp20["47-2042.00"] = "Floor Layers (except carpet, wood & hard tiles)"
tmp20["47-2043.00"] = "Floor Sanders & Finishers"
tmp20["47-2044.00"] = "Tile & Marble Setters"
tmp20["47-2051.00"] = "Cement Masons & Concrete Finishers"
tmp20["47-2053.00"] = "Terrazzo Workers & Finishers"
tmp20["47-2061.00"] = "Construction Laborers"
tmp20["47-2071.00"] = "Paving, Surfacing & Tamping Equipment Operators"
tmp20["47-2072.00"] = "Pile-Driver Operators"
tmp20["47-2073.00"] = "Operating Engineers & Construction Equipment Operators"
tmp20["47-2081.00"] = "Drywall & Ceiling Tile Installers"
tmp20["47-2082.00"] = "Tapers"
tmp20["47-2111.00"] = "Electricians"
tmp20["47-2121.00"] = "Glaziers"
tmp20["47-2131.00"] = "Insulation Workers - Floor, Ceiling & Wall"
tmp20["47-2132.00"] = "Insulation Workers - Mechanical"
tmp20["47-2141.00"] = "Painters - Construction & Maintenance"
tmp20["47-2142.00"] = "Paperhangers"
tmp20["47-2151.00"] = "Pipelayers"
tmp20["47-2152.01"] = "Pipe Fitters & Steamfitters"
tmp20["47-2152.02"] = "Plumbers"
tmp20["47-2161.00"] = "Plasterers & Stucco Masons"
tmp20["47-2171.00"] = "Reinforcing Iron & Rebar Workers"
tmp20["47-2181.00"] = "Roofers"
tmp20["47-2211.00"] = "Sheet Metal Workers"
tmp20["47-2221.00"] = "Structural Iron & Steel Workers"
tmp20["47-3011.00"] = "Helpers - Brickmasons, Stonemasons & Setters"
tmp20["47-3012.00"] = "Helpers - Carpenters"
tmp20["47-3013.00"] = "Helpers - Electricians"
tmp20["47-3014.00"] = "Helpers - Painters, Paperhangers & Plasterers"
tmp20["47-3015.00"] = "Helpers - Pipelayers, Plumbers & Pipefitters"
tmp20["47-3016.00"] = "Helpers - Roofers"
tmp20["47-3019.99"] = "Helpers - Construction, Other"
tmp20["47-4011.00"] = "Construction & Building Inspectors"
tmp20["47-4021.00"] = "Elevator Installers & Repairers"
tmp20["47-4031.00"] = "Fence Erectors"
tmp20["47-4041.00"] = "Hazardous Materials Removal Workers"
tmp20["47-4051.00"] = "Highway Maintenance Workers"
tmp20["47-4061.00"] = "Rail-Track Laying & Maintenance Equipment Operators"
tmp20["47-4071.00"] = "Septic Tank Servicers & Sewer Pipe Cleaners"
tmp20["47-4091.00"] = "Segmental Pavers"
tmp20["47-4099.99"] = "Construction & Related Workers, Other"
tmp20["47-5011.00"] = "Derrick Operators - Oil & Gas"
tmp20["47-5012.00"] = "Rotary Drill Operators - Oil & Gas"
tmp20["47-5013.00"] = "Service Unit Operators - Oil, Gas & Mining"
tmp20["47-5021.00"] = "Earth Drillers (except oil & gas)"
tmp20["47-5031.00"] = "Explosives Workers - Ordnance Handling Experts & Blasters"
tmp20["47-5041.00"] = "Continuous Mining Machine Operators"
tmp20["47-5042.00"] = "Mine Cutting & Channeling Machine Operators"
tmp20["47-5049.99"] = "Mining Machine Operators, Other"
tmp20["47-5051.00"] = "Rock Splitters - Quarry"
tmp20["47-5061.00"] = "Roof Bolters - Mining"
tmp20["47-5071.00"] = "Roustabouts - Oil & Gas"
tmp20["47-5081.00"] = "Helpers - Extraction Workers"
tmp20["47-5099.99"] = "Extraction Workers, Other"
tmp19["careers"] = tmp20
tmp20 = null
oCareersData["47"] = tmp19
tmp19 = null
var tmp20 = new Object
tmp20["category_title"] = "Installation, Maintenance, & Repair"
var tmp21 = new Object
tmp21["49-1011.00"] = "Managers of Mechanics, Installers & Repairers"
tmp21["49-2011.00"] = "Computer, Automated Teller & Office Machine Repairers"
tmp21["49-2021.00"] = "Radio Mechanics"
tmp21["49-2022.00"] = "Telecommunications Equipment Installers & Repairers"
tmp21["49-2091.00"] = "Avionics Technicians"
tmp21["49-2092.00"] = "Electric Motor & Power Tool Repairers"
tmp21["49-2093.00"] = "Electrical Installers/Repairers - Transportation Equipment"
tmp21["49-2094.00"] = "Electrical Repairers - Commercial & Industrial Equipment"
tmp21["49-2095.00"] = "Electrical Repairers - Powerhouse, Substation & Relay"
tmp21["49-2096.00"] = "Electronic Equipment Installers - Motor Vehicles"
tmp21["49-2097.00"] = "Electronic Home Entertainment Equipment Installers"
tmp21["49-2098.00"] = "Security & Fire Alarm Systems Installers"
tmp21["49-3011.00"] = "Aircraft Mechanics & Service Technicians"
tmp21["49-3021.00"] = "Automotive Body & Related Repairers"
tmp21["49-3022.00"] = "Automotive Glass Installers & Repairers"
tmp21["49-3023.01"] = "Automotive Master Mechanics"
tmp21["49-3023.02"] = "Automotive Specialty Technicians"
tmp21["49-3031.00"] = "Bus & Truck Mechanics and Diesel Engine Specialists"
tmp21["49-3041.00"] = "Farm Equipment Mechanics"
tmp21["49-3042.00"] = "Mobile Heavy Equipment Mechanics (except engines)"
tmp21["49-3043.00"] = "Rail Car Repairers"
tmp21["49-3051.00"] = "Motorboat Mechanics"
tmp21["49-3052.00"] = "Motorcycle Mechanics"
tmp21["49-3053.00"] = "Outdoor Power Equipment & Other Small Engine Mechanics"
tmp21["49-3091.00"] = "Bicycle Repairers"
tmp21["49-3092.00"] = "Recreational Vehicle Service Technicians"
tmp21["49-3093.00"] = "Tire Repairers & Changers"
tmp21["49-9011.00"] = "Mechanical Door Repairers"
tmp21["49-9012.00"] = "Control & Valve Installers & Repairers (except mechanical door)"
tmp21["49-9021.01"] = "Heating & Air Conditioning Mechanics"
tmp21["49-9021.02"] = "Refrigeration Mechanics"
tmp21["49-9031.00"] = "Home Appliance Repairers"
tmp21["49-9041.00"] = "Industrial Machinery Mechanics"
tmp21["49-9042.00"] = "Maintenance & Repair Workers - General"
tmp21["49-9043.00"] = "Maintenance Workers - Machinery"
tmp21["49-9044.00"] = "Millwrights"
tmp21["49-9045.00"] = "Refractory Materials Repairers (except brickmasons)"
tmp21["49-9051.00"] = "Electrical Power-Line Installers & Repairers"
tmp21["49-9052.00"] = "Telecommunications Line Installers & Repairers"
tmp21["49-9061.00"] = "Camera & Photographic Equipment Repairers"
tmp21["49-9062.00"] = "Medical Equipment Repairers"
tmp21["49-9063.00"] = "Musical Instrument Repairers & Tuners"
tmp21["49-9064.00"] = "Watch Repairers"
tmp21["49-9069.99"] = "Precision Instrument & Equipment Repairers, Other"
tmp21["49-9091.00"] = "Coin, Vending & Amusement Machine Servicers/Repairers"
tmp21["49-9092.00"] = "Commercial Divers"
tmp21["49-9093.00"] = "Fabric Menders (except garment)"
tmp21["49-9094.00"] = "Locksmiths & Safe Repairers"
tmp21["49-9095.00"] = "Manufactured Building & Mobile Home Installers"
tmp21["49-9096.00"] = "Riggers"
tmp21["49-9097.00"] = "Signal & Track Switch Repairers"
tmp21["49-9098.00"] = "Helpers - Installation, Maintenance & Repair Workers"
tmp21["49-9099.99"] = "Installation, Maintenance & Repair Workers, Other"
tmp20["careers"] = tmp21
tmp21 = null
oCareersData["49"] = tmp20
tmp20 = null
var tmp21 = new Object
tmp21["category_title"] = "Manufacturing & Production"
var tmp22 = new Object
tmp22["51-1011.00"] = "Managers of Production & Operating Workers"
tmp22["51-2011.00"] = "Aircraft Assemblers - Structure, Surfaces, Rigging & Systems"
tmp22["51-2021.00"] = "Coil Winders, Tapers & Finishers"
tmp22["51-2022.00"] = "Electrical & Electronic Equipment Assemblers"
tmp22["51-2023.00"] = "Electromechanical Equipment Assemblers"
tmp22["51-2031.00"] = "Engine & Other Machine Assemblers"
tmp22["51-2041.00"] = "Structural Metal Fabricators & Fitters"
tmp22["51-2091.00"] = "Fiberglass Laminators & Fabricators"
tmp22["51-2092.00"] = "Team Assemblers"
tmp22["51-2093.00"] = "Timing Device Assemblers, Adjusters & Calibrators"
tmp22["51-2099.99"] = "Assemblers & Fabricators, Other"
tmp22["51-3011.00"] = "Bakers"
tmp22["51-3021.00"] = "Butchers & Meat Cutters"
tmp22["51-3022.00"] = "Meat, Poultry & Fish Cutters/Trimmers"
tmp22["51-3023.00"] = "Slaughterers & Meat Packers"
tmp22["51-3091.00"] = "Food & Tobacco Roasting, Baking & Drying Machine Operators"
tmp22["51-3092.00"] = "Food Batchmakers"
tmp22["51-3093.00"] = "Food Cooking Machine Operators & Tenders"
tmp22["51-4011.00"] = "Computer-Controlled Machine Tool Operators - Metal and Plastic"
tmp22["51-4012.00"] = "Numerical Tool & Process Control Programmers"
tmp22["51-4021.00"] = "Extruding & Drawing Machine Setters, Operators & Tenders"
tmp22["51-4022.00"] = "Forging Machine Setters, Operators & Tenders"
tmp22["51-4023.00"] = "Rolling Machine Setters, Operators & Tenders"
tmp22["51-4031.00"] = "Cutting, Punching & Press Machine Setters, Operators & Tenders - Metal and Plastic"
tmp22["51-4032.00"] = "Drilling & Boring Machine Tool Setters, Operators & Tenders"
tmp22["51-4033.00"] = "Grinding, Lapping, Polishing & Buffing Machine Tool Setters, Operators & Tenders"
tmp22["51-4034.00"] = "Lathe & Turning Machine Tool Setters, Operators & Tenders"
tmp22["51-4035.00"] = "Milling & Planing Machine Setters, Operators & Tenders"
tmp22["51-4041.00"] = "Machinists"
tmp22["51-4051.00"] = "Metal-Refining Furnace Operators & Tenders"
tmp22["51-4052.00"] = "Pourers & Casters - Metal"
tmp22["51-4061.00"] = "Model Makers - Metal & Plastic"
tmp22["51-4062.00"] = "Patternmakers - Metal & Plastic"
tmp22["51-4071.00"] = "Foundry Mold & Coremakers"
tmp22["51-4072.00"] = "Molding, Coremaking & Casting Machine Setters, Operators & Tenders - Metal and Plastic"
tmp22["51-4081.00"] = "Multiple Machine Tool Setters, Operators & Tenders - Metal and Plastic"
tmp22["51-4111.00"] = "Tool & Die Makers"
tmp22["51-4121.06"] = "Welders, Cutters & Welder Fitters"
tmp22["51-4121.07"] = "Solderers & Brazers"
tmp22["51-4122.00"] = "Welding, Soldering & Brazing Machine Setters, Operators & Tenders"
tmp22["51-4191.00"] = "Heat Treating Equipment Setters, Operators & Tenders - Metal and Plastic"
tmp22["51-4192.00"] = "Lay-Out Workers - Metal & Plastic"
tmp22["51-4193.00"] = "Plating & Coating Machine Setters, Operators & Tenders - Metal and Plastic"
tmp22["51-4194.00"] = "Tool Grinders, Filers & Sharpeners"
tmp22["51-4199.99"] = "Metal Workers & Plastic Workers, Other"
tmp22["51-5011.00"] = "Bindery Workers"
tmp22["51-5012.00"] = "Bookbinders"
tmp22["51-5021.00"] = "Job Printers"
tmp22["51-5022.00"] = "Prepress Technicians & Workers"
tmp22["51-5023.00"] = "Printing Machine Operators"
tmp22["51-6011.00"] = "Laundry & Dry-Cleaning Workers"
tmp22["51-6021.00"] = "Pressers - Textile & Garment"
tmp22["51-6031.00"] = "Sewing Machine Operators"
tmp22["51-6041.00"] = "Shoe & Leather Workers & Repairers"
tmp22["51-6042.00"] = "Shoe Machine Operators & Tenders"
tmp22["51-6051.00"] = "Sewers - Hand"
tmp22["51-6052.00"] = "Tailors, Dressmakers & Custom Sewers"
tmp22["51-6061.00"] = "Textile Bleaching & Dyeing Machine Operators & Tenders"
tmp22["51-6062.00"] = "Textile Cutting Machine Setters, Operators & Tenders"
tmp22["51-6063.00"] = "Textile Knitting & Weaving Machine Setters & Operators"
tmp22["51-6064.00"] = "Textile Winding, Twisting & Drawing Out Machine Operators"
tmp22["51-6091.00"] = "Extruding & Forming Machine Setters, Operators & Tenders - Synthetic & Glass Fibers"
tmp22["51-6092.00"] = "Fabric & Apparel Patternmakers"
tmp22["51-6093.00"] = "Upholsterers"
tmp22["51-6099.99"] = "Textile, Apparel & Furnishings Workers, Other"
tmp22["51-7011.00"] = "Cabinetmakers & Bench Carpenters"
tmp22["51-7021.00"] = "Furniture Finishers"
tmp22["51-7031.00"] = "Model Makers - Wood"
tmp22["51-7032.00"] = "Patternmakers - Wood"
tmp22["51-7041.00"] = "Sawing Machine Setters, Operators & Tenders - Wood"
tmp22["51-7042.00"] = "Woodworking Machine Setters, Operators & Tenders"
tmp22["51-7099.99"] = "Woodworkers, Other"
tmp22["51-8011.00"] = "Nuclear Power Reactor Operators"
tmp22["51-8012.00"] = "Power Distributors & Dispatchers"
tmp22["51-8013.00"] = "Power Plant Operators"
tmp22["51-8021.00"] = "Stationary Engineers & Boiler Operators"
tmp22["51-8031.00"] = "Water & Liquid Waste Treatment Plant & System Operators"
tmp22["51-8091.00"] = "Chemical Plant & System Operators"
tmp22["51-8092.00"] = "Gas Plant Operators"
tmp22["51-8093.00"] = "Petroleum Pump System Operators, Refinery Operators & Gaugers"
tmp22["51-8099.99"] = "Plant & System Operators, Other"
tmp22["51-9011.00"] = "Chemical Equipment Operators & Tenders"
tmp22["51-9012.00"] = "Separating, Filtering, Clarifying & Still Machine Operators"
tmp22["51-9021.00"] = "Crushing, Grinding & Polishing Machine Operators"
tmp22["51-9022.00"] = "Grinding & Polishing Workers - Hand"
tmp22["51-9023.00"] = "Mixing & Blending Machine Setters, Operators & Tenders"
tmp22["51-9031.00"] = "Cutters & Trimmers - Hand"
tmp22["51-9032.00"] = "Cutting & Slicing Machine Setters, Operators & Tenders"
tmp22["51-9041.00"] = "Extruding, Forming, Pressing & Compacting Machine Setters, Operators & Tenders"
tmp22["51-9051.00"] = "Furnace, Kiln, Oven, Drier & Kettle Operators & Tenders"
tmp22["51-9061.00"] = "Inspectors, Testers, Sorters, Samplers & Weighers"
tmp22["51-9071.01"] = "Jewelers"
tmp22["51-9071.06"] = "Gem & Diamond Workers"
tmp22["51-9071.07"] = "Precious Metal Workers"
tmp22["51-9081.00"] = "Dental Laboratory Technicians"
tmp22["51-9082.00"] = "Medical Appliance Technicians"
tmp22["51-9083.00"] = "Ophthalmic Laboratory Technicians"
tmp22["51-9111.00"] = "Packaging & Filling Machine Operators & Tenders"
tmp22["51-9121.00"] = "Coating, Painting & Spraying Machine Setters, Operators & Tenders"
tmp22["51-9122.00"] = "Painters - Transportation Equipment"
tmp22["51-9123.00"] = "Painting, Coating & Decorating Workers"
tmp22["51-9131.00"] = "Photographic Process Workers"
tmp22["51-9132.00"] = "Photographic Processing Machine Operators"
tmp22["51-9141.00"] = "Semiconductor Processors"
tmp22["51-9191.00"] = "Cementing & Gluing Machine Operators & Tenders"
tmp22["51-9192.00"] = "Cleaning, Washing & Metal Pickling Equipment Operators"
tmp22["51-9193.00"] = "Cooling & Freezing Equipment Operators & Tenders"
tmp22["51-9194.00"] = "Etchers & Engravers"
tmp22["51-9195.03"] = "Stone Cutters & Carvers - Manufacturing"
tmp22["51-9195.04"] = "Glass Blowers, Molders, Benders & Finishers"
tmp22["51-9195.05"] = "Potters - Manufacturing"
tmp22["51-9195.07"] = "Molding & Casting Workers"
tmp22["51-9196.00"] = "Paper Goods Machine Setters, Operators & Tenders"
tmp22["51-9197.00"] = "Tire Builders"
tmp22["51-9198.00"] = "Helpers - Production Workers"
tmp22["51-9199.99"] = "Production Workers, Other"
tmp21["careers"] = tmp22
tmp22 = null
oCareersData["51"] = tmp21
tmp21 = null
var tmp22 = new Object
tmp22["category_title"] = "Transportation & Material Moving"
var tmp23 = new Object
tmp23["53-1011.00"] = "Aircraft Cargo Handling Supervisors"
tmp23["53-1021.00"] = "Managers of Helpers, Laborers & Material Movers - Hand"
tmp23["53-1031.00"] = "Managers of Transportation & Vehicle Operators"
tmp23["53-2011.00"] = "Airline Pilots, Copilots & Flight Engineers"
tmp23["53-2012.00"] = "Commercial Pilots"
tmp23["53-2021.00"] = "Air Traffic Controllers"
tmp23["53-2022.00"] = "Airfield Operations Specialists"
tmp23["53-3011.00"] = "Ambulance Drivers & Attendants (except EMTs)"
tmp23["53-3021.00"] = "Bus Drivers - Transit & Intercity"
tmp23["53-3022.00"] = "Bus Drivers - School"
tmp23["53-3031.00"] = "Driver/Sales Workers"
tmp23["53-3032.00"] = "Truck Drivers - Heavy & Tractor-Trailer"
tmp23["53-3033.00"] = "Truck Drivers - Light or Delivery Services"
tmp23["53-3041.00"] = "Taxi Drivers & Chauffeurs"
tmp23["53-3099.99"] = "Motor Vehicle Operators, Other"
tmp23["53-4011.00"] = "Locomotive Engineers"
tmp23["53-4012.00"] = "Locomotive Firers"
tmp23["53-4013.00"] = "Rail Yard Engineers, Dinkey Operators & Hostlers"
tmp23["53-4021.00"] = "Railroad Brake, Signal & Switch Operators"
tmp23["53-4031.00"] = "Railroad Conductors & Yardmasters"
tmp23["53-4041.00"] = "Subway & Streetcar Operators"
tmp23["53-4099.99"] = "Rail Transportation Workers, Other"
tmp23["53-5011.00"] = "Sailors & Marine Oilers"
tmp23["53-5021.01"] = "Ship & Boat Captains"
tmp23["53-5021.02"] = "Mates - Ship, Boat & Barge"
tmp23["53-5021.03"] = "Pilots - Ship"
tmp23["53-5022.00"] = "Motorboat Operators"
tmp23["53-5031.00"] = "Ship Engineers"
tmp23["53-6011.00"] = "Bridge & Lock Tenders"
tmp23["53-6021.00"] = "Parking Lot Attendants"
tmp23["53-6031.00"] = "Service Station Attendants"
tmp23["53-6041.00"] = "Traffic Technicians"
tmp23["53-6051.01"] = "Aviation Inspectors"
tmp23["53-6051.07"] = "Transportation Vehicle, Equipment & Systems Inspectors"
tmp23["53-6051.08"] = "Freight & Cargo Inspectors"
tmp23["53-6099.99"] = "Transportation Workers, Other"
tmp23["53-7011.00"] = "Conveyor Operators & Tenders"
tmp23["53-7021.00"] = "Crane & Tower Operators"
tmp23["53-7031.00"] = "Dredge Operators"
tmp23["53-7032.00"] = "Excavating & Loading Machine and Dragline Operators"
tmp23["53-7033.00"] = "Loading Machine Operators - Underground Mining"
tmp23["53-7041.00"] = "Hoist & Winch Operators"
tmp23["53-7051.00"] = "Industrial Truck & Tractor Operators"
tmp23["53-7061.00"] = "Cleaners of Vehicles & Equipment"
tmp23["53-7062.00"] = "Freight, Stock & Material Movers and Longshoremen"
tmp23["53-7063.00"] = "Machine Feeders & Offbearers"
tmp23["53-7064.00"] = "Packers & Packagers"
tmp23["53-7071.00"] = "Gas Compressor & Gas Pumping Station Operators"
tmp23["53-7072.00"] = "Pump Operators (except wellhead pumpers)"
tmp23["53-7073.00"] = "Wellhead Pumpers"
tmp23["53-7081.00"] = "Refuse & Recyclable Material Collectors"
tmp23["53-7111.00"] = "Shuttle Car Operators"
tmp23["53-7121.00"] = "Tank Car, Truck & Ship Loaders"
tmp23["53-7199.99"] = "Material Moving Workers, Other"
tmp22["careers"] = tmp23
tmp23 = null
oCareersData["53"] = tmp22
tmp22 = null
var tmp23 = new Object
tmp23["category_title"] = "Military"
var tmp24 = new Object
tmp24["55-1011.00"] = "Air Crew Officers"
tmp24["55-1012.00"] = "Aircraft Launch & Recovery Officers"
tmp24["55-1013.00"] = "Armored Assault Vehicle Officers"
tmp24["55-1014.00"] = "Artillery & Missile Officers"
tmp24["55-1015.00"] = "Command & Control Center Officers"
tmp24["55-1016.00"] = "Infantry Officers"
tmp24["55-1017.00"] = "Special Forces Officers"
tmp24["55-1019.99"] = "Military Officer Special & Tactical Operations Leaders/Managers, Other"
tmp24["55-2011.00"] = "Supervisors/Managers of Air Crew Members"
tmp24["55-2012.00"] = "Supervisors/Managers of Weapons Specialists/Crew Members"
tmp24["55-2013.00"] = "Supervisors/Managers of All Other Tactical Operations Specialists"
tmp24["55-3011.00"] = "Air Crew Members"
tmp24["55-3012.00"] = "Aircraft Launch & Recovery Specialists"
tmp24["55-3013.00"] = "Armored Assault Vehicle Crew Members"
tmp24["55-3014.00"] = "Artillery & Missile Crew Members"
tmp24["55-3015.00"] = "Command & Control Center Specialists"
tmp24["55-3016.00"] = "Infantry"
tmp24["55-3017.00"] = "Radar & Sonar Technicians"
tmp24["55-3018.00"] = "Special Forces"
tmp24["55-3019.99"] = "Military Enlisted Tactical Operations & Air/Weapons Specialists and Crew, Other"
tmp23["careers"] = tmp24
tmp24 = null
oCareersData["55"] = tmp23
tmp23 = null


function init()
{
var categories = document.search_form.career_category;
if (categories && categories.selectedIndex > 0)
{
career_category_change('');
}
}

function career_category_change(sSelectedValue)
{

var categories = document.search_form.career_category;
var careers = document.search_form.career;

if (categories && careers)
{

if (categories.selectedIndex == 0)
{
careers.options[0].text = '-- Select Career --';
careers.options.length = 1;
careers.disabled = true;
}
else
{
var aCareerData = oCareersData[categories.options[categories.selectedIndex].value]['careers'];

careers.options[0].selected = true;
careers.options[0].text = '-- Select Career --';
careers.options[0].value = '';

var i = 1;
for (var career_id in aCareerData)
{
careers.options.length = i + 1;
careers.options[i].value = career_id;
careers.options[i].text = aCareerData[career_id];
if (typeof(sSelectedValue) != 'undefined' && sSelectedValue == career_id) careers.options[i].selected = true;
i++;
}

careers.disabled = false;
}
}
}


//-->
</script>
</code>

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-13 : 00:41:14
do the population by means of series of insert statements like
I think easiest way would be to make id field (category_id,career_id) of integer and identity type so that you can do like

DECLARE @CategoryID int

INSERT Career_Category
(category_title)
VALUES('Management')

SET @CategoryID = SCOPE_IDENTITY()

INSERT Career
(career_title,
category_id )
VALUES
('Chief Executives',@CategoryID),
('General & Operations Managers',@CategoryID)
('Legislators',@CategoryID)
..



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -