[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
170	19	1989-03-03	Finance	dragan0@adventure-works.com	Dragan Tomic	117-555-0185	663843431	Dragan	M	2021-02-28	Tomic	adventure-works\dragan0	M	K	142	2	117-555-0185			51	2021-02-28	Current	Accounts Payable Specialist	63
96	19	1988-03-11	Finance	candy0@adventure-works.com	Candy Spoon	920-555-0177	60517918	Candy	F	2021-01-23	Spoon	adventure-works\candy0	S	L	142	2	920-555-0177			50	2021-01-23	Current	Accounts Receivable Specialist	61
182	26.4423	1988-01-21	Finance	barbara1@adventure-works.com	Barbara Moreland	822-555-0145	363910111	Barbara	F	2021-03-07	Moreland	adventure-works\barbara1	M	C	142	2	822-555-0145		1	49	2021-03-07	Current	Accountant	58
133	19	1996-10-07	Finance	bryan1@adventure-works.com	Bryan Walton	935-555-0199	931190412	Bryan	M	2021-02-10	Walton	adventure-works\bryan1	S	A	142	2	935-555-0199			51	2021-02-10	Current	Accounts Receivable Specialist	62
205	19	1991-03-26	Finance	janet0@adventure-works.com	Janet Sheperdigian	393-555-0186	519756660	Janet	F	2021-03-18	Sheperdigian	adventure-works\janet0	M	L	142	2	393-555-0186			52	2021-03-18	Current	Accounts Payable Specialist	64
220	26.4423	1991-07-18	Finance	mike0@adventure-works.com	Mike Seamans	927-555-0150	480951955	Mike	M	2021-03-25	Seamans	adventure-works\mike0	S	K	142	2	927-555-0150		1	49	2021-03-25	Current	Accountant	59
61	19	1988-03-23	Finance	deborah0@adventure-works.com	Deborah Poe	602-555-0194	363923697	Deborah	F	2021-01-04	Poe	adventure-works\deborah0	M	E	142	2	602-555-0194			50	2021-01-04	Current	Accounts Receivable Specialist	60

Generated 2026-07-17 12:59:53.445 UTC