Query - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Query

Author

Topic

ssenthilnathan20
Starting Member

2 Posts

Posted - 2009-04-28 : 08:43:34

hi

I have table

select E.FullName,E.DepartmentID,S.NoOfWorkingDays,F.Percentage,S.CalculatedAmount

from Employee E left join T5052_P009 S on E.EmployeeID=S.EmployeeID left join T5052_C010 F on

E.EmployeeID=F.EmployeeID WHERE (E.CompanyID = 1) AND ( E.EmployeeId in ( 145, 190, 203, 204, 239, 258, 259, 261, 262, 306, 308, 309, 416, 417 )) group by E.DepartmentID,E.FullName,S.NoOfWorkingDays,F.Percentage,S.CalculatedAmount

Execute query output below like

Ben Miller 29 NULL NULL NULL
David Bradley 29 NULL NULL NULL
Eric Hagins 29 NULL NULL NULL
Eric Kurjan 29 NULL NULL NULL
Frank Pellow 29 NULL NULL NULL
Fukiko Ogisu 29 NULL NULL NULL
Gail Erickson 29 NULL NULL NULL
Gordon Hee 29 NULL NULL NULL
Jae Pak 29 NULL NULL NULL
Jian Shuo Wang 29 NULL NULL NULL
John Wood 29 NULL NULL NULL
Jossef Goldberg 29 NULL NULL NULL
dasda dadasda 31 NULL NULL NULL
qeqeq eqweqe 45 NULL NULL NULL

but i want

deptId = 29

Ben Miller 29 NULL NULL NULL
David Bradley 29 NULL NULL NULL
Eric Hagins 29 NULL NULL NULL
Eric Kurjan 29 NULL NULL NULL
Frank Pellow 29 NULL NULL NULL
Fukiko Ogisu 29 NULL NULL NULL
Gail Erickson 29 NULL NULL NULL
Gordon Hee 29 NULL NULL NULL
Jae Pak 29 NULL NULL NULL
Jian Shuo Wang 29 NULL NULL NULL
John Wood 29 NULL NULL NULL
Jossef Goldberg 29 NULL NULL NULL

deptId = 31
dasda dadasda 31 NULL NULL NULL

deptId = 45
qeqeq eqweqe 45 NULL NULL NULL

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-28 : 09:31:10

It is very easy to do in your reporting application.

E 12°55'05.63"
N 56°04'39.26"