Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
praveen050
Starting Member
9 Posts |
Posted - 2012-06-05 : 05:10:34
|
query to show manager of each Employeeo/pEmpID EmpNAme Department ManagerID Manager NameEMP002 Zuckerman, Larry HR EMP001 Zuniga, AlbertoEMP003 Zucker, Al IT EMP001 Zuniga, AlbertoEMP004 Zoll, Kelly Finance EMP001 Zuniga, Alberto Query to Update the table with Manager Department where Employee Department Is missingEmpID EmpNAme ManagerID DepartmentEMP001 Zuniga,Alberto CEOEMP002 Zuckerman,Larry EMP001 HREMP003 Zucker,Al EMP001 ITEMP004 Zoll,Kelly EMP001 FinanceEMP005 Zimmershead,Michael EMP002 HREMP006 Zimmerman,Beverly EMP002 EMP007 Zimmerman Alejandro EMP002 HREMP008 Ziegler, Melissa EMP003 HREMP009 Ziegler,James EMP003 EMP010 Ziegler, Jacalyn EMP003 HREMP011 Ziegler, Greg EMP003 HREMP012 Ziarnik, Adam EMP004 Finance |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-06-05 : 05:35:44
|
Looks like you are wanting us to do your job.That's not funny. No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
|