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 |
sapthagiri
Starting Member
2 Posts |
Posted - 2014-06-30 : 02:30:53
|
Hi,Q1:Emp_id Name Reporting1 Suresh 12 Ramesh 23 kumar 3 4 rajesh 35 raju 3how to disply empid name find out the reporting person Q2:emp_id month salary1 jan 150001 feb 300001 mar 200002 jan 400002 feb 500002 mar 600003 jan 700003 Feb 800003 Mar 90000disply quarter wise and gridoutput:Emp_id Jan Feb Mar 1 15000 30000 200002 40000 50000 600003 70000 80000 90000sapthagiri9884450326 |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2014-06-30 : 08:38:34
|
quote: Originally posted by sapthagiri Hi,Q1:Emp_id Name Reporting1 Suresh 12 Ramesh 23 kumar 3 4 rajesh 35 raju 3how to disply empid name find out the reporting person SELECT t.Emp_id, t.Name, t2.Name ReportingPersonFROM TableName tJOIN TableName t2 ON t.Reporting = t2.Emp_idQ2:emp_id month salary1 jan 150001 feb 300001 mar 200002 jan 400002 feb 500002 mar 600003 jan 700003 Feb 800003 Mar 90000disply quarter wise and gridSELECT *FROM TableNamePIVOT (SUM(salary) FOR Months IN ([Jan],[Feb],[Mar]))Poutput:Emp_id Jan Feb Mar 1 15000 30000 200002 40000 50000 600003 70000 80000 90000sapthagiri9884450326
--Chandu |
|
|
sapthagiri
Starting Member
2 Posts |
Posted - 2014-07-01 : 00:44:53
|
Thanks alotsapthagiri9884450326 |
|
|
|
|
|