[ROOT]  dt  DimEmployee  <  WHERE ParentEmployeeId EQ '142'  >   

7 items

DimEmployeeId	BaseRate	BirthDate	Department	EmailAddress	EmergencyContactName	EmergencyContactPhone	EmployeeNationalIDAlternateKey	FirstName	Gender	HireDate	LastName	LoginID	MaritalStatus	MiddleName	ParentEmployeeId	PayFrequency	Phone	Photo	SalariedFlag	SickLeaveHours	StartDate	Status	Title	VacationHours
96	19	1988-03-10	Finance	candy0@adventure-works.com	Candy Spoon	920-555-0177	60517918	Candy	F	2021-01-22	Spoon	adventure-works\candy0	S	L	142	2	920-555-0177			50	2021-01-22	Current	Accounts Receivable Specialist	61
133	19	1996-10-06	Finance	bryan1@adventure-works.com	Bryan Walton	935-555-0199	931190412	Bryan	M	2021-02-09	Walton	adventure-works\bryan1	S	A	142	2	935-555-0199			51	2021-02-09	Current	Accounts Receivable Specialist	62
61	19	1988-03-22	Finance	deborah0@adventure-works.com	Deborah Poe	602-555-0194	363923697	Deborah	F	2021-01-03	Poe	adventure-works\deborah0	M	E	142	2	602-555-0194			50	2021-01-03	Current	Accounts Receivable Specialist	60
170	19	1989-03-02	Finance	dragan0@adventure-works.com	Dragan Tomic	117-555-0185	663843431	Dragan	M	2021-02-27	Tomic	adventure-works\dragan0	M	K	142	2	117-555-0185			51	2021-02-27	Current	Accounts Payable Specialist	63
182	26.4423	1988-01-20	Finance	barbara1@adventure-works.com	Barbara Moreland	822-555-0145	363910111	Barbara	F	2021-03-06	Moreland	adventure-works\barbara1	M	C	142	2	822-555-0145		1	49	2021-03-06	Current	Accountant	58
205	19	1991-03-25	Finance	janet0@adventure-works.com	Janet Sheperdigian	393-555-0186	519756660	Janet	F	2021-03-17	Sheperdigian	adventure-works\janet0	M	L	142	2	393-555-0186			52	2021-03-17	Current	Accounts Payable Specialist	64
220	26.4423	1991-07-17	Finance	mike0@adventure-works.com	Mike Seamans	927-555-0150	480951955	Mike	M	2021-03-24	Seamans	adventure-works\mike0	S	K	142	2	927-555-0150		1	49	2021-03-24	Current	Accountant	59

Generated 2026-07-16 18:57:02.055 UTC