How get All Day Name Day Wise of a Month in SQL

--exec spGetAllDayOfAMonth 2012,1
ALTER Procedure [dbo].[spGetAllDayOfAMonth]
@pYear int,@mnth int
AS
BEGIN
SELECT convert(varchar,day(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )) as SL,
(convert(varchar,day(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number ))
+ '-' +
datename(weekday,CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )) as DayMonth

FROM master..spt_values
WHERE type = 'P'
AND
(CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME) + Number )
<
DATEADD(mm,1,CAST(CAST(@pYear AS VARCHAR) + '-' + CAST(@mnth AS VARCHAR) + '-01' AS DATETIME))
END

The Different Types of Doctors Specialty

The Different Types of Doctors

1. Cardiologist

Cardiologist is actually a sub-specialty of Internal Medicine. The cardiologist focuses on treatment of the heart and blood vessels of the circulatory system.

2. Dermatologist

A dermatologist deals with skin problems.

3. Endocrinologist

Endocrinologist is also a sub-specialty of Internal Medicine. This doctor treats people endocrine or gland problems. Glands are organs that produce and secrete hormones necessary to control and regulate bodily functions. Patients with thyroid problems and diabetics are treated by endocrinologists.

4. Gastrologist

A gastrologist focuses diagnosis and treatment on the gastric area or the stomach.

5. Gastroenterologist

Gastroenterologist is also a sub-specialty of Internal Medicine. A gastroenterologist deals with digestive system problems.He diagnoses and treats disorders of the gastrointestinal tract, including the esophagus, stomach, small intestine, large intestine, pancreas, liver, gallbladder, and biliary system.

6. Gynecologist

A gynecologist deals with the diseases of the female reproductive system.

7. Infectious Disease Specialist

Infectious Disease is a sub-specialty of Internal Medicine. Infectious disease doctors deal with problems like the swine flu, bird flu, as well as HIV/AIDS, among other communicable diseases.

8. Internal Medicine Specialist

Internal medicine specialists diagnoses and treats general medical disorders of adults such as diabetes, high blood pressure, heart disease, emphysema, and cancer.

9. Nephrologist

Nephrologists treat kidney diseases and prescribe dialysis for patients whose kidneys fail to function.

10. Opthalmologist

Opthalmologists are doctors who treat the eye for medical and surgical problems

11. Otolaryngologists

Otolaryngologists are also known as otorhinolaryngologists. They are usually referred to as E.N.T.s which means “ Ear, Nose, and Throat specialist. These doctors deal treat sinus problems, allergies, head and neck cancers, among others.

12. Pediatrician

Pediatricians are doctors who care for infants up to adolescent patients (usually 18 years old). They do immunizations, school physical exams, among others.

13. Podiatrist

A podiatrist is a doctor who specializes on the diagnosis and treatment of the ailments of the foot.

14. Psychiatrist

A psychiatrist diagnoses and treats patients with mental disorders.

15. Pulmonologists

Pulmonologists are doctors who diagnose and treat problems of the respiratory system, including the lungs.

16. Rheumatologist

Rheumatologists deal with treatment of arthritis and other diseases of the joints, muscles and bones.

17. Surgeon

Surgeons perform surgery which is an invasive form of medical treatment. It involves cutting of a part of the body to remove a diseased organ or to repair a tear or breakage.