SQL Query Output to HTML

ANNIVERSAR	WEEK	DOW	THUMBNAIL	NAME	AGE
01/01/2016	1	6		Arthur B. Schafer	51
01/01/2016	1	6		Sarah Ann Netzband	32
01/01/2016	1	6		Emmlyn Mackay Brock	1
01/03/2016	2	1		Joanne Dunn Gaffey	79
01/03/2016	2	1		Robin Lynn Washburn	55
01/03/2016	2	1		Michael Lindsey	45
01/06/2016	2	4		Shelley Tyler	47
01/07/2016	2	5		Rebecca Wagner	33
01/09/2016	2	7		James Doyle Schafer	29
01/09/2016	2	7		Peggy Gaffey	53
01/09/2016	2	7		Danielle Salisbury	26
01/09/2016	2	7		Mary Francis Haley	44
01/10/2016	3	1		Beth Johnnson	53
01/12/2016	3	3		Julianna Rose Finnerty	17
01/13/2016	3	4		Michelle Baulf	34
01/14/2016	3	5		Thomas Dunn	13
01/15/2016	3	6		Molly Schafer	26
01/15/2016	3	6		Joel B. Haley	64
01/16/2016	3	7		Grace Deborah Link	4
01/17/2016	4	1		Nancy Wilder	56
01/18/2016	4	2		Virginia Gaffey	59
01/18/2016	4	2		Gary Hugh Finnerty Jr.	48
01/18/2016	4	2		Kayla Davis	31
01/18/2016	4	2		Richard Paul Sharpe	37
01/19/2016	4	3		Alan J. Gaffey	55
01/19/2016	4	3		Lauren Catherine Haley	28
01/21/2016	4	5		Joe A Albanoski, Jr	65
01/22/2016	4	6		James Dunn	76
01/22/2016	4	6		Thomas Haley	59
01/25/2016	5	2		Jessica Bennett	27
01/26/2016	5	3		Kathy Mary Kolhepp	58
01/27/2016	5	4		Barbara Grant	74
01/27/2016	5	4		Robert Simpson	45
01/28/2016	5	5		Thomas Patrick Finnerty<	47
01/28/2016	5	5		Jeffrey Updyke	46
01/28/2016	5	5		Donna Reid	49
01/29/2016	5	6		Anja Dunn	3
01/31/2016	6	1		Kelly Gaffey	46
02/01/2016	6	2		Patrick Dunn	24
02/02/2016	6	3		Thomas Schafer	68
02/03/2016	6	4		Stacy Lynn Haley	42
02/04/2016	6	5		Michael Mack	28
02/06/2016	6	7		Kim Slasinski	36
02/08/2016	7	2		Kevin Davis Jr	32
02/10/2016	7	4		William Mackay Brock	30
02/11/2016	7	5		Hannah Simpson	2
02/15/2016	8	2		Steven Schafer	20
02/15/2016	8	2		Ann Joan O'Connor	74
02/15/2016	8	2		Marjorie Goldthwait	76
02/15/2016	8	2		Caleb Daniel King	10
02/16/2016	8	3		Andrea Hall	37
02/17/2016	8	4		Debra Ann Gaffey	56
02/22/2016	9	2		Katherine A Charney	66
02/26/2016	9	6		Paul Haley	61
02/27/2016	9	7		John Albanoski	57
02/27/2016	9	7		Tricia Marie Haley	37
03/01/2016	10	3		Edward LaBarge	57
03/02/2016	10	4		Kelly Kirch	55
03/03/2016	10	5		Michele Charney	63
03/05/2016	10	7		Tanner Updyke	12
03/08/2016	11	3		Ashley Salisbury	28
03/12/2016	11	7		Anthony Moore	41
03/16/2016	12	4		Morgan Cora Finnerty	20
03/19/2016	12	7		Lindsey Updyke	19
03/19/2016	12	7		Peter W Charney	60
03/19/2016	12	7		Bradley Michael Taylor	44
03/19/2016	12	7		Jordyn Jay Hall	1
03/21/2016	13	2		Andrew LaBarge	28
03/21/2016	13	2		Rochelle Terese Gaffey	49
03/21/2016	13	2		Diana Lynn Taylor	41
03/22/2016	13	3		Joshua LaBarge	26
03/22/2016	13	3		Kathi Baxter Gaffey	51
03/23/2016	13	4		Matt Spring	38
03/24/2016	13	5		Rosalee Gaffey	62
03/27/2016	14	1		Imogene Gaffey	66
03/28/2016	14	2		John Dunn	43
03/31/2016	14	5		Keith LaBarge	56
04/01/2016	14	6		William Joseph Cavanaugh	75
04/03/2016	15	1		Kathleen Wilder	57
04/03/2016	15	1		Nancy Haley	68
04/04/2016	15	2		Charles Gardener	11
04/04/2016	15	2		Alexander Simpson	17
04/06/2016	15	4		Edwin G. Haley	72
04/09/2016	15	7		David Gaffey	73
04/11/2016	16	2		Dale Washburn	67
04/12/2016	16	3		Deana Jae Washburn	23
04/13/2016	16	4		Ereine Martha Mulvaney	90
04/15/2016	16	6		Paula Sue Wilder	47
04/17/2016	17	1		Barbara Johnnson	48
04/19/2016	17	3		Stephen Mack	25
04/21/2016	17	5		Patricia Ann Ryan	73
04/22/2016	17	6		Marina Leytman	78
04/22/2016	17	6		Kevin Davis	56
04/23/2016	17	7		Stephen Lindsey	58
04/28/2016	18	5		Joseph Alan Bell	58
04/28/2016	18	5		Connor Dunn	5
05/01/2016	19	1		Jeffery Gaffey	52
05/02/2016	19	2		Brittney Schafer	25
05/02/2016	19	2		Patricia Simpson	34
05/04/2016	19	4		Mary Cronk	71
05/05/2016	19	5		Alan Gaffey	31
05/05/2016	19	5		Patricia Washburn	64
05/08/2016	20	1		Josephine Haley	68
05/09/2016	20	2		Trinity Reece	19
05/11/2016	20	4		Anna Finebloot	83
05/13/2016	20	6		Tom Blackiston	38
05/13/2016	20	6		Barbara Jean Pickard	53
05/15/2016	21	1		Virginia Haley	60
05/17/2016	21	3		Louis Gaffey	35
05/18/2016	21	4		Kevin Dunn	41
05/20/2016	21	6		Kara Testa	14
05/23/2016	22	2		Shane Haley	51
05/24/2016	22	3		Finley Thomas Brock	4
05/25/2016	22	4		Samuel Bennett	22
05/27/2016	22	6		Elizabeth Haley	32
05/30/2016	23	2		Michael Dunn	66
05/30/2016	23	2		Joan Charney	53
05/30/2016	23	2		Mary Lynn Pickard	56
05/31/2016	23	3		Peter Haley	53
06/03/2016	23	6		Kourtney Davis	26
06/06/2016	24	2		Mary Lynn Haley	60
06/08/2016	24	4		Ruth Gaffey	80
06/11/2016	24	7		Robert M. Haley	70
06/13/2016	25	2		Matthew Justin Morgan	39
06/13/2016	25	2		Karen Annette Haley	52
06/14/2016	25	3		Raymond Warren King	52
06/20/2016	26	2		Ryley Gaffey	12
06/23/2016	26	5		Ryan Dunn	21
06/24/2016	26	6		Jake Hall	35
06/24/2016	26	6		Virginia Kennedy	79
06/27/2016	27	2		Andrea Jo Haley	32
07/01/2016	27	6		Joseph Fitzgerald	69
07/01/2016	27	6		Louis Cavanaugh	67
07/01/2016	27	6		Margaret Fitzgerald	73
07/01/2016	27	6		John David Cavanaugh	73
07/01/2016	27	6		Kathleen Cavanaugh	70
07/01/2016	27	6		Lawrence Cavanaugh	52
07/01/2016	27	6		Joseph Cavanaugh	44
07/01/2016	27	6		William Cavanaugh	41
07/01/2016	27	6		Justin Grant	28
07/01/2016	27	6		Eric Grant	25
07/01/2016	27	6		Jason Grant	22
07/01/2016	27	6		Ginger Fitzgerald	43
07/01/2016	27	6		Daniel Fitzgerald	41
07/01/2016	27	6		Christopher Fitzgerald	45
07/01/2016	27	6		Brandy Cavanaugh	31
07/01/2016	27	6		Christina Cavanaugh	24
07/01/2016	27	6		Christopher Cavanaugh	18
07/01/2016	27	6		John Parish	32
07/01/2016	27	6		Joseph Parish	30
07/01/2016	27	6		Tristan Cavanaugh	18
07/01/2016	27	6		Aerial Cavanaugh	19
07/01/2016	27	6		Jeffrey William Cavanaug	18
07/01/2016	27	6		Semera Elia	24
07/01/2016	27	6		Sierra Elia	21
07/01/2016	27	6		Alyssa Haley	22
07/02/2016	27	7		Benjamin Simpson	13
07/03/2016	28	1		Mary Ann Dunn	70
07/03/2016	28	1		Richard Haley	49
07/03/2016	28	1		Colin Andrew Haley	46
07/04/2016	28	2		Steven Haley	51
07/05/2016	28	3		David Gaffey Jr	49
07/07/2016	28	5		Virginnia Dunn	81
07/07/2016	28	5		Denise Alice Haley	55
07/10/2016	29	1		Tom Washburn	53
07/12/2016	29	3		Brandy Keith	38
07/13/2016	29	4		Ava Loraine Davis	3
07/15/2016	29	6		Arianna Milliman	11
07/17/2016	30	1		Daniel B. Schafer	29
07/17/2016	30	1		Jason Gaffey	29
07/20/2016	30	4		Cianan Patrick McCoy	5
07/20/2016	30	4		Richard Simpson	66
07/22/2016	30	6		Robert Arthur Pickard	52
07/23/2016	30	7		Landon Gaffey	8
07/24/2016	31	1		Karl E LaBarge Jr.	55
07/26/2016	31	3		Eileen Dunn	77
07/27/2016	31	4		Joshua Gaffey	25
07/28/2016	31	5		Kelly Lynn Washburn	34
07/31/2016	32	1		Dana Sharon	52
07/31/2016	32	1		Cynthia Marlene King	55
08/01/2016	32	2		Jennifer Johnnson	46
08/03/2016	32	4		Barbara Haley	66
08/07/2016	33	1		Whitney Gaffey	19
08/08/2016	33	2		Marilyn Schafer	84
08/08/2016	33	2		Michele Dunn	52
08/08/2016	33	2		Michael Dunn	52
08/09/2016	33	3		Farra Alexander McClearn	4
08/10/2016	33	4		Heather McCoy	39
08/12/2016	33	6	Aaron_Milliman_1021-02	Aaron Milliman	38
08/13/2016	33	7		Jordan Thomas Finnerty	18
08/13/2016	33	7		Melissa Boulahanis	29
08/13/2016	33	7		Mary Weeg Haley	75
08/15/2016	34	2		William J. LaBarge	54
08/15/2016	34	2		Carny Hall	61
08/16/2016	34	3		William Dunn	21
08/16/2016	34	3		Luke Michael Haley	45
08/17/2016	34	4		Zachary William Gaffey	14
08/17/2016	34	4		Alan B. Haley	70
08/19/2016	34	6		Nicholas Haley	39
08/20/2016	34	7		Freja Simpson	10
08/24/2016	35	4		Bailey Gaffey	11
08/26/2016	35	6		Shaelan Grace Finnerty	11
08/26/2016	35	6		Hailey Dunn	17
09/01/2016	36	5		Katelyn Testa	17
09/01/2016	36	5		William Taylor	65
09/02/2016	36	6		Jason Anthony Gaffey	6
09/02/2016	36	6		Theresa Haley	57
09/03/2016	36	7		Clare Gaffey	25
09/08/2016	37	5		Jennifer Gaffey	41
09/08/2016	37	5		Greg Mccoy	65
09/13/2016	38	3		Leon Haley	47
09/15/2016	38	5		Veronica Haley	50
09/16/2016	38	6		Lauren B. LaBarge	25
09/17/2016	38	7		Richard Albanoski	61
09/17/2016	38	7		Ronald E. Haley	74
09/19/2016	39	2		Cara Spring	41
09/19/2016	39	2		Anette Pederson	41
09/20/2016	39	3		Timothy M Haley	38
09/22/2016	39	5		Christopher Haley	56
09/24/2016	39	7		Haley Updyke	18
09/26/2016	40	2		John Gaffey	57
09/26/2016	40	2		Katherine Dunn Testa	37
09/26/2016	40	2		James Haley	49
09/27/2016	40	3		Eileen Haley	38
09/29/2016	40	5		Tiffany Gaffey	26
09/30/2016	40	6		Makenzie Gaffey	10
09/30/2016	40	6		Joseph A. Haley	64
10/01/2016	40	7		Pierre LaBarge	24
10/01/2016	40	7		Nicholas Robert Charney<	29
10/02/2016	41	1		Russell B. LaBarge	28
10/02/2016	41	1		Eleanor Marie Mack	2
10/11/2016	42	3		Ludmila Leytman	58
10/11/2016	42	3		Morgan Mack	19
10/12/2016	42	4		James D. Haley	74
10/16/2016	43	1		Norman Leach	63
10/23/2016	44	1		Robert Schafer	34
10/24/2016	44	2		Jim Dunn	51
10/25/2016	44	3		Jacob Scott	25
10/26/2016	44	4		Mary Charney	59
10/26/2016	44	4		Elizabeth Charney	57
10/26/2016	44	4		John W. Haley	77
10/29/2016	44	7		Liam Gabriel King	8
11/01/2016	45	3		Kim Schafer	39
11/01/2016	45	3		David Joseph Perella	63
11/02/2016	45	4		Laura Dunn	50
11/04/2016	45	6		James Schafer	64
11/06/2016	46	1		Lori Ann Schebel	42
11/09/2016	46	4		Christopher Patrick Char	26
11/09/2016	46	4		Debra Ann Schebel	46
11/10/2016	46	5		Rachel Gaffey	23
11/18/2016	47	6		Darren Gaffey	17
11/18/2016	47	6		Robert Leon Washburn	47
11/21/2016	48	2		Colleen O'Connor	64
11/21/2016	48	2		Aidan Hugh Finnerty	19
11/23/2016	48	4		Patrick McCoy	37
11/26/2016	48	7		Briana Lynn Sharpe King<	38
11/27/2016	49	1		Margaret Haley	65
11/28/2016	49	2		Catherine Haley	67
11/30/2016	49	4		Dawn Haley	74
12/02/2016	49	6		Andrew Bennett	24
12/03/2016	49	7		Bill Gaffey	38
12/03/2016	49	7		Timothy Haley	59
12/08/2016	50	5		Mary Nasci	54
12/08/2016	50	5		David Haley	29
12/09/2016	50	6		Colton Thomas Gaffey	6
12/10/2016	50	7		Rose Marie Dunn McCoy	62
12/10/2016	50	7		Amanda Dunn	36
12/11/2016	51	1		Thomas Schafer	29
12/11/2016	51	1		Samantha Hall	30
12/15/2016	51	5		Abigail Simpson	15
12/15/2016	51	5		Shane Haley	28
12/16/2016	51	6		Emma Haley	5
12/16/2016	51	6		Frederick Paul Sharpe	61
12/16/2016	51	6		Kimberly Johnnson	52
12/18/2016	52	1		Jeremy Paul Haley	34
12/24/2016	52	7		Haley Blackiston	3
12/26/2016	53	2		Ellen Dunn	63
12/28/2016	53	4		Irene Gaffey	78
12/28/2016	53	4		Cheryl Rae Washburn	43
12/31/2016	53	7		Josephine Ann Janisewski	58
12/31/2016	53	7		David Haley	55

SELECT EVAL('{^2016-'+TWODIGIT(MONTH(BI.BORN))+'-'+TWODIGIT(DAY(BI.BORN))+'}') anniversary, 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,50,' ') Name,SPAN(AGE(BI.BORN),'age' ) Age FROM C:\JPG\BIRTHDAYMV.DBF BI order by 1