Useful SQL Server scripts
This Blog is about MSSQL server 2000/2005 and 2008
Monday, April 06, 2009
XML File Sample
First Name
Last Name
Email Address
Gender
Birth Date
What type of relationship are you looking for?
Membership Agreement
Email Alerts
Body Type
Height
Eye Color
Hair Color
Languages Spoken
Originally from
Occupation
Education
Relationship Status
About Kids
Number of Children
Number of Children at Home
Religion
Do you smoke?
Do you drink?
Ethnicity
Which of these are your favorite type of music?
Which of these are your favorite type of movie?
Which outdoor activities are you most interested in?
Which of these activities do you enjoy the most?
When going somewhere...
Are you a trendy person?
Favorite types of food
What is your political leaning?
Introduce yourself and describe the type of person you'd like to meet.
What would you like to do on a first date?
Self-description
Favorite bands and musicians
Favorite movies and actors
Favorite TV shows
My idea of a great trip
Favorite restaurants
Schools attended
IMPORTANT:
Age
Location
Height
IMPORTANT:
Body Type
Education
Relationship Status
Religion
Ethnicity
Smoking
Drinking
Ideal Match Emails
Who am I and what am I looking for?
What would I like to do on a first date?
Why you should get to know me:
What good things have past relationships taught me?
Some of the most important things in my life are:
How would I describe my perfect day?
A few more things I would like to add:
Question of the Week
You must enter a valid, working email address.
Slender
Washboard
Athletic
Average
I should maybe lose a few
Large but muscular
Full-figured
I'll tell you later
I don't have kids but I would like to
I have kids and I would like more
I don't have kids and I wouldn't like to have any
I have kids and I wouldn't like more
0
1
2
3
4
5+
on special occasions
several times a year
once or twice a month
every week
It is very important
It is somewhat important
It is starting to be important
I'm honestly not sure
within 50 miles
within 100 miles
within 300 miles
within 500 miles
within 1000 miles
anywhere
Never
Rarely
On occasion
Frequently
As much as possible
I'll tell you later
High School
Technical School
Associate degree
Professional degree
College Freshman
College Sophomore
College Junior
College Senior
Bachelor's degree
Graduate Student
Master's degree
Doctoral degree
African
Asian
Black / African descent
Caribbean
Caucasian / White
East Indian
Hispanic / Latino
Middle Eastern
Native American
Pacific Islands
Other
Select Gender
Male
Female
Single - never been married
Divorced
Legally separated
Widowed
Agnostic
Anglican
Atheist
Bahai
Baptist
Born Again
Buddhist
Catholic
Christian
Confucian
Interdenominational
Hindu
Islamic / Muslim
Jewish
Lutheran
Methodist
Mormon/Latter-day Saint
Orthodox
Pagan/Wiccan/Umbanda
Presbyterian
Protestant
Seventh-Day Adventist
Taoist
Unitarian Universalist
Zoroastrian
I'm not affiliated with any religion
I'm not religious
Other
Never
On occasion
Frequently
Whenever I can
American
Argentine
Barbeque
Brazilian
Cajun/Southern
Caribbean/Cuban
Chinese
European
Fast food
French
German
Greek
Indian
Italian
Japanese
Jewish/Kosher
Korean
Mediterranean
Mexican
Persian
Seafood
Southwestern
Spanish
Thai
Vegetarian/Vegan
Vietnamese
Aerobics
Art
Clubs
Cars
Charity/Volunteering
Collecting
Computers
Cooking/Culinary arts
Crafts
Dancing
Games
Martial Arts
Movies/TV
Music
Opera/Theater
Politics
Reading
Restaurants
Shopping
Sports
Weightlifting
Action/Adventure
Cartoons
Comedy
Documentary
Drama
Foreign Films
Horror
Musical
Mystery
Romance
Science Fiction
Suspense/Thriller
Western
Ambient
Blues
Classical
Classic Rock
Contemporary
Country/Western
Dance/Disco
Folk
Funk
Gospel
Heavy Metal
Hip Hop
Jazz
Movie Soundtracks
Newwave
Oldies
Opera
Pop/Top 40
Punk
Rap
Reggae
Religious Music
Rock n Roll
Soft Rock
Soul/Rhythm and Blues
Techno/Rave/Jungle
World
Automobiles/Motorcycles
Basketball
Biking
Birdwatching
Camping/Hiking/Fishing
Gardening
Golf
Horseback riding
Photography
Running
Sailing
SCUBA Diving
Snow Skiing/Snowboarding
Sports/Athletics
Sunbathing
Surfing
Swimming
Tennis
Traveling/Sightseeing
Water Skiing/Windsurfing
Conservative
Into the wind
Liberal
Moderate
Open Minded
Socialist
Ultra Conservative
I am usually a little late
I am usually early
I am usually on time
I usually forget to show up
I'm star of the show.
I don't need advice!
I don't care about the latest fashions
I dress to be comfortable
I'm a somewhat fashionable person
I'm a very trendy person
Aquarius
Pisces
Aries
Gemini
Virgo
Capricorn
Cancer
Leo
Sagittarius
Libra
Scorpio
Taurus
Neon
Not sure
Not important to me
0
1
2
3
4
5+
Black
Blue
Brown
Gray
Green
Hazel
Other
Red
Violet
Auburn
Black
Blonde
Dark Brown
Gray
Light Brown
Other
Red
Silver
Strawberry
Strawberry Blonde
White
Bald
Dates
Friends
Marriage
Afrikaans
Arabic
Chinese
Dutch
English
Fijian
French
German
Greek
Hebrew
Italian
Japanese
Korean
Mandarin
Polish
Portuguese
Russian
Samoan
Spanish
Tongan
Other
inactive_bonus
bad_email
3' 0" (91 cm)
3' 1" (93 cm)
3' 2" (96 cm)
3' 3" (99 cm)
3' 4" (101 cm)
3' 5" (104 cm)
3' 6" (106 cm)
3' 7" (109 cm)
3' 8" (111 cm)
3' 9" (114 cm)
3' 10" (116 cm)
3' 11" (119 cm)
4' 0" (121 cm)
4' 1" (124 cm)
4' 2" (127 cm)
4' 3" (129 cm)
4' 4" (132 cm)
4' 5" (134 cm)
4' 6" (137 cm)
4' 7" (139 cm)
4' 8" (142 cm)
4' 9" (144 cm)
4' 10" (147 cm)
4' 11" (149 cm)
5' 0" (152 cm)
5' 1" (154 cm)
5' 2" (157 cm)
5' 3" (160 cm)
5' 4" (162 cm)
5' 5" (165 cm)
5' 6" (167 cm)
5' 7" (170 cm)
5' 8" (172 cm)
5' 9" (175 cm)
5' 10" (177 cm)
5' 11" (180 cm)
6' 0" (182 cm)
6' 1" (185 cm)
6' 2" (187 cm)
6' 3" (190 cm)
6' 4" (193 cm)
6' 5" (195 cm)
6' 6" (198 cm)
6' 7" (200 cm)
6' 8" (203 cm)
6' 9" (205 cm)
6' 10" (208 cm)
6' 11" (210 cm)
7' 0" (213 cm)
7' 1" (215 cm)
7' 2" (218 cm)
7' 3" (220 cm)
7' 4" (223 cm)
7' 5" (226 cm)
7' 6" (228 cm)
3' 0" (91 cm)
3' 1" (93 cm)
3' 2" (96 cm)
3' 3" (99 cm)
3' 4" (101 cm)
3' 5" (104 cm)
3' 6" (106 cm)
3' 7" (109 cm)
3' 8" (111 cm)
3' 9" (114 cm)
3' 10" (116 cm)
3' 11" (119 cm)
4' 0" (121 cm)
4' 1" (124 cm)
4' 2" (127 cm)
4' 3" (129 cm)
4' 4" (132 cm)
4' 5" (134 cm)
4' 6" (137 cm)
4' 7" (139 cm)
4' 8" (142 cm)
4' 9" (144 cm)
4' 10" (147 cm)
4' 11" (149 cm)
5' 0" (152 cm)
5' 1" (154 cm)
5' 2" (157 cm)
5' 3" (160 cm)
5' 4" (162 cm)
5' 5" (165 cm)
5' 6" (167 cm)
5' 7" (170 cm)
5' 8" (172 cm)
5' 9" (175 cm)
5' 10" (177 cm)
5' 11" (180 cm)
6' 0" (182 cm)
6' 1" (185 cm)
6' 2" (187 cm)
6' 3" (190 cm)
6' 4" (193 cm)
6' 5" (195 cm)
6' 6" (198 cm)
6' 7" (200 cm)
6' 8" (203 cm)
6' 9" (205 cm)
6' 10" (208 cm)
6' 11" (210 cm)
7' 0" (213 cm)
7' 1" (215 cm)
7' 2" (218 cm)
7' 3" (220 cm)
7' 4" (223 cm)
7' 5" (226 cm)
7' 6" (228 cm)
3' 0" (91 cm)
3' 1" (93 cm)
3' 2" (96 cm)
3' 3" (99 cm)
3' 4" (101 cm)
3' 5" (104 cm)
3' 6" (106 cm)
3' 7" (109 cm)
3' 8" (111 cm)
3' 9" (114 cm)
3' 10" (116 cm)
3' 11" (119 cm)
4' 0" (121 cm)
4' 1" (124 cm)
4' 2" (127 cm)
4' 3" (129 cm)
4' 4" (132 cm)
4' 5" (134 cm)
4' 6" (137 cm)
4' 7" (139 cm)
4' 8" (142 cm)
4' 9" (144 cm)
4' 10" (147 cm)
4' 11" (149 cm)
5' 0" (152 cm)
5' 1" (154 cm)
5' 2" (157 cm)
5' 3" (160 cm)
5' 4" (162 cm)
5' 5" (165 cm)
5' 6" (167 cm)
5' 7" (170 cm)
5' 8" (172 cm)
5' 9" (175 cm)
5' 10" (177 cm)
5' 11" (180 cm)
6' 0" (182 cm)
6' 1" (185 cm)
6' 2" (187 cm)
6' 3" (190 cm)
6' 4" (193 cm)
6' 5" (195 cm)
6' 6" (198 cm)
6' 7" (200 cm)
6' 8" (203 cm)
6' 9" (205 cm)
6' 10" (208 cm)
6' 11" (210 cm)
7' 0" (213 cm)
7' 1" (215 cm)
7' 2" (218 cm)
7' 3" (220 cm)
7' 4" (223 cm)
7' 5" (226 cm)
7' 6" (228 cm)
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
50%
60%
70%
80%
90%
100%
Not important
Desirable
Somewhat important
Important
Very important
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment