SQL Query Output to HTML

1

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
6		Arthur B. Schafer	51	01/01/2016
6		Sarah Ann Netzband	32	01/01/2016

2

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Joanne Dunn Gaffey	79	01/03/2016
1		Robin Lynn Washburn	55	01/03/2016
1		Michael Lindsey	45	01/03/2016
4		Shelley Tyler	47	01/06/2016
5		Rebecca Wagner	33	01/07/2016
7		James Doyle Schafer	29	01/09/2016
7		Peggy Gaffey	53	01/09/2016
7		Danielle Salisbury	26	01/09/2016
7		Mary Francis Haley	44	01/09/2016

3

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Beth Johnnson	53	01/10/2016
3		Julianna Rose Finnerty	17	01/12/2016
4		Michelle Baulf	34	01/13/2016
5		Thomas Dunn	13	01/14/2016
6		Molly Schafer	26	01/15/2016
6		Joel B. Haley	64	01/15/2016
7		Grace Deborah Link	4	01/16/2016

4

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Nancy Wilder	56	01/17/2016
2		Virginia Gaffey	59	01/18/2016
2		Gary Hugh Finnerty Jr.	48	01/18/2016
2		Kayla Davis	31	01/18/2016
2		Richard Paul Sharpe	37	01/18/2016
3		Alan J. Gaffey	55	01/19/2016
3		Lauren Catherine Haley	28	01/19/2016
5		Joe A Albanoski, Jr	65	01/21/2016
6		James Dunn	76	01/22/2016
6		Thomas Haley	59	01/22/2016

5

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Jessica Bennett	27	01/25/2016
3		Kathy Mary Kolhepp	58	01/26/2016
4		Barbara Grant	74	01/27/2016
4		Robert Simpson	45	01/27/2016
5		Thomas Patrick Finnerty<	47	01/28/2016
5		Jeffrey Updyke	46	01/28/2016
5		Donna Reid	49	01/28/2016
6		Anja Dunn	3	01/29/2016

6

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Kelly Gaffey	46	01/31/2016
2		Patrick Dunn	24	02/01/2016
3		Thomas Schafer	68	02/02/2016
4		Stacy Lynn Haley	42	02/03/2016
5		Michael Mack	28	02/04/2016
7		Kim Slasinski	36	02/06/2016

7

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Kevin Davis Jr	32	02/08/2016
4		William Mackay Brock	30	02/10/2016

8

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Steven Schafer	20	02/15/2016
2		Ann Joan O'Connor	74	02/15/2016
2		Marjorie Goldthwait	76	02/15/2016
2		Caleb Daniel King	10	02/15/2016
3		Andrea Hall	37	02/16/2016
4		Debra Ann Gaffey	56	02/17/2016

9

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Katherine A Charney	66	02/22/2016
6		Paul Haley	61	02/26/2016
7		John Albanoski	57	02/27/2016
7		Tricia Marie Haley	37	02/27/2016

10

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
3		Edward LaBarge	57	03/01/2016
4		Kelly Kirch	55	03/02/2016
5		Michele Charney	63	03/03/2016
7		Tanner Updyke	12	03/05/2016

11

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
3		Ashley Salisbury	28	03/08/2016

12

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
4		Morgan Cora Finnerty	20	03/16/2016
7		Lindsey Updyke	19	03/19/2016
7		Peter W Charney	60	03/19/2016
7		Bradley Michael Taylor	44	03/19/2016
7		Jordyn Jay Hall	1	03/19/2016

13

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Andrew LaBarge	28	03/21/2016
2		Rochelle Terese Gaffey	49	03/21/2016
2		Diana Lynn Taylor	41	03/21/2016
3		Joshua LaBarge	26	03/22/2016
3		Kathi Baxter Gaffey	51	03/22/2016
4		Matt Spring	38	03/23/2016
5		Rosalee Gaffey	62	03/24/2016

14

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Imogene Gaffey	66	03/27/2016
2		John Dunn	43	03/28/2016
5		Keith LaBarge	56	03/31/2016
6		William Joseph Cavanaugh	75	04/01/2016

15

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Kathleen Wilder	57	04/03/2016
1		Nancy Haley	68	04/03/2016
2		Charles Gardener	11	04/04/2016
2		Alexander Simpson	17	04/04/2016
4		Edwin G. Haley	72	04/06/2016
7		David Gaffey	73	04/09/2016

16

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Dale Washburn	67	04/11/2016
3		Deana Jae Washburn	23	04/12/2016
4		Ereine Martha Mulvaney	90	04/13/2016
6		Paula Sue Wilder	47	04/15/2016

17

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Barbara Johnnson	48	04/17/2016
3		Stephen Mack	25	04/19/2016
5		Patricia Ann Ryan	73	04/21/2016
6		Marina Leytman	78	04/22/2016
6		Kevin Davis	56	04/22/2016
7		Stephen Lindsey	58	04/23/2016

18

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
5		Joseph Alan Bell	58	04/28/2016
5		Connor Dunn	5	04/28/2016

19

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Jeffery Gaffey	52	05/01/2016
2		Brittney Schafer	25	05/02/2016
2		Patricia Simpson	34	05/02/2016
4		Mary Cronk	71	05/04/2016
5		Alan Gaffey	31	05/05/2016
5		Patricia Washburn	64	05/05/2016

20

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Josephine Haley	68	05/08/2016
2		Trinity Reece	19	05/09/2016
4		Anna Finebloot	83	05/11/2016
6		Tom Blackiston	38	05/13/2016
6		Barbara Jean Pickard	53	05/13/2016

21

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Virginia Haley	60	05/15/2016
3		Louis Gaffey	35	05/17/2016
4		Kevin Dunn	41	05/18/2016
6		Kara Testa	14	05/20/2016

22

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Shane Haley	51	05/23/2016
3		Finley Thomas Brock	4	05/24/2016
4		Samuel Bennett	22	05/25/2016
6		Elizabeth Haley	32	05/27/2016

23

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Michael Dunn	66	05/30/2016
2		Joan Charney	53	05/30/2016
2		Mary Lynn Pickard	56	05/30/2016
3		Peter Haley	53	05/31/2016
6		Kourtney Davis	26	06/03/2016

24

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Mary Lynn Haley	60	06/06/2016
4		Ruth Gaffey	80	06/08/2016
7		Robert M. Haley	70	06/11/2016

25

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Matthew Justin Morgan	39	06/13/2016
2		Karen Annette Haley	52	06/13/2016
3		Raymond Warren King	52	06/14/2016

26

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Ryley Gaffey	12	06/20/2016
5		Ryan Dunn	21	06/23/2016
6		Jake Hall	35	06/24/2016
6		Virginia Kennedy	79	06/24/2016

27

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Andrea Jo Haley	32	06/27/2016
6		Joseph Fitzgerald	69	07/01/2016
6		Louis Cavanaugh	67	07/01/2016
6		Alyssa Haley	22	07/01/2016
7		Benjamin Simpson	13	07/02/2016

28

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Mary Ann Dunn	70	07/03/2016
1		Richard Haley	49	07/03/2016
1		Colin Andrew Haley	46	07/03/2016
2		Steven Haley	51	07/04/2016
3		David Gaffey Jr	49	07/05/2016
5		Virginnia Dunn	81	07/07/2016
5		Denise Alice Haley	55	07/07/2016

29

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Tom Washburn	53	07/10/2016
3		Brandy Keith	38	07/12/2016
6		Arianna Milliman	11	07/15/2016

30

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Daniel B. Schafer	29	07/17/2016
1		Jason Gaffey	29	07/17/2016
4		Cianan Patrick McCoy	5	07/20/2016
4		Richard Simpson	66	07/20/2016
6		Robert Arthur Pickard	52	07/22/2016
7		Landon Gaffey	8	07/23/2016

31

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Karl E LaBarge Jr.	55	07/24/2016
3		Eileen Dunn	77	07/26/2016
4		Joshua Gaffey	25	07/27/2016
5		Kelly Lynn Washburn	34	07/28/2016

32

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Dana Sharon	52	07/31/2016
1		Cynthia Marlene King	55	07/31/2016
2		Jennifer Johnnson	46	08/01/2016
4		Barbara Haley	66	08/03/2016

33

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Whitney Gaffey	19	08/07/2016
2		Marilyn Schafer	84	08/08/2016
2		Michele Dunn	52	08/08/2016
2		Michael Dunn	52	08/08/2016
3		Farra Alexander McClearn	4	08/09/2016
4		Heather McCoy	39	08/10/2016
6	Aaron_Milliman_1021-02	Aaron Milliman	38	08/12/2016
7		Jordan Thomas Finnerty	18	08/13/2016
7		Melissa Boulahanis	29	08/13/2016
7		Mary Weeg Haley	75	08/13/2016

34

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		William J. LaBarge	54	08/15/2016
2		Carny Hall	61	08/15/2016
3		William Dunn	21	08/16/2016
3		Luke Michael Haley	45	08/16/2016
4		Zachary William Gaffey	14	08/17/2016
4		Alan B. Haley	70	08/17/2016
6		Nicholas Haley	39	08/19/2016
7		Freja Simpson	10	08/20/2016

35

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
4		Bailey Gaffey	11	08/24/2016
6		Shaelan Grace Finnerty	11	08/26/2016
6		Hailey Dunn	17	08/26/2016

36

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
5		Katelyn Testa	17	09/01/2016
5		William Taylor	65	09/01/2016
6		Jason Anthony Gaffey	6	09/02/2016
6		Theresa Haley	57	09/02/2016
7		Clare Gaffey	25	09/03/2016

37

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
5		Jennifer Gaffey	41	09/08/2016
5		Greg Mccoy	65	09/08/2016

38

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
3		Leon Haley	47	09/13/2016
5		Veronica Haley	50	09/15/2016
6		Lauren B. LaBarge	25	09/16/2016
7		Richard Albanoski	61	09/17/2016
7		Ronald E. Haley	74	09/17/2016

39

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Cara Spring	41	09/19/2016
2		Anette Pederson	41	09/19/2016
3		Timothy M Haley	38	09/20/2016
5		Christopher Haley	56	09/22/2016
7		Haley Updyke	18	09/24/2016

40

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		John Gaffey	57	09/26/2016
2		Katherine Dunn Testa	37	09/26/2016
2		James Haley	49	09/26/2016
3		Eileen Haley	38	09/27/2016
5		Tiffany Gaffey	26	09/29/2016
6		Makenzie Gaffey	10	09/30/2016
6		Joseph A. Haley	64	09/30/2016
7		Pierre LaBarge	24	10/01/2016
7		Nicholas Robert Charney<	29	10/01/2016

41

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Russell B. LaBarge	28	10/02/2016
1		Eleanor Marie Mack	2	10/02/2016

42

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
3		Ludmila Leytman	58	10/11/2016
3		Morgan Mack	19	10/11/2016
4		James D. Haley	74	10/12/2016

43

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Norman Leach	63	10/16/2016

44

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Robert Schafer	34	10/23/2016
2		Jim Dunn	51	10/24/2016
3		Jacob Scott	25	10/25/2016
4		Mary Charney	59	10/26/2016
4		Elizabeth Charney	57	10/26/2016
4		John W. Haley	77	10/26/2016
7		Liam Gabriel King	8	10/29/2016

45

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
3		Kim Schafer	39	11/01/2016
3		David Joseph Perella	63	11/01/2016
4		Laura Dunn	50	11/02/2016
6		James Schafer	64	11/04/2016

46

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Lori Ann Schebel	42	11/06/2016
4		Christopher Patrick Char	26	11/09/2016
4		Debra Ann Schebel	46	11/09/2016
5		Rachel Gaffey	23	11/10/2016

47

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
6		Darren Gaffey	17	11/18/2016
6		Robert Leon Washburn	47	11/18/2016

48

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Colleen O'Connor	64	11/21/2016
2		Aidan Hugh Finnerty	19	11/21/2016
4		Patrick McCoy	37	11/23/2016
7		Briana Lynn Sharpe King<	38	11/26/2016

49

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Margaret Haley	65	11/27/2016
2		Catherine Haley	67	11/28/2016
4		Dawn Haley	74	11/30/2016
6		Andrew Bennett	24	12/02/2016
7		Bill Gaffey	38	12/03/2016
7		Timothy Haley	59	12/03/2016

50

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
5		Mary Nasci	54	12/08/2016
5		David Haley	29	12/08/2016
7		Rose Marie Dunn McCoy	62	12/10/2016
7		Amanda Dunn	36	12/10/2016

51

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Thomas Schafer	29	12/11/2016
1		Samantha Hall	30	12/11/2016
5		Abigail Simpson	15	12/15/2016
5		Shane Haley	28	12/15/2016
6		Frederick Paul Sharpe	61	12/16/2016
6		Kimberly Johnnson	52	12/16/2016

52

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
1		Jeremy Paul Haley	34	12/18/2016
7		Haley Blackiston	3	12/24/2016

53

DOW	THUMBNAIL	NAME	AGE	ANNIVERSARY
2		Ellen Dunn	63	12/26/2016
4		Irene Gaffey	78	12/28/2016
4		Cheryl Rae Washburn	43	12/28/2016
7		Josephine Ann Janisewski	58	12/31/2016
7		David Haley	55	12/31/2016

SELECT WEEK(EVAL('{^2016-'+TWODIGIT(MONTH(BI.BORN))+'-'+TWODIGIT(DAY(BI.BORN))+'}')) week ,DOW( EVAL('{^2016-'+TWODIGIT(MONTH(BI.BORN))+'-'+TWODIGIT(DAY(BI.BORN))+'}') ) dow, BI.THUMBNAIL,padr(BI.NAME,120,' ') Name,SPAN(AGE(BI.BORN),'age' ) Age,EVAL('{^2016-'+TWODIGIT(MONTH(BI.BORN))+'-'+TWODIGIT(DAY(BI.BORN))+'}') anniversary FROM C:\JPG\BIRTHDAYMV.DBF BI WHERE LEN(ALLTRIM(BI.THUMBNAIL)) > 20 order by 1 ,2