Help in modifying 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)

Help in modifying Query

Author

Topic

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2008-11-21 : 06:11:10

Currently I am getting Data as following
Type Day1 Day2

New 10 Null
New Null 5
Old 10 Null
Old Null 5
Cons 10 Null
Cons Null 5

The query for the above result is
select t.type as Type,
case when d.daytype = 1 then d.days end as Day1
case when d.daytype = 2 then d.days end as Day2
from daysdetails d
left join typedetails t
on d.typeid = t.typeid

but i would like to get data as below

Type Day1 Day2

New 10 5
Old 10 5
Cons 10 5

Plz help me in modifying my query

Kamran Shahid
Sr. Software Engineer(MCSD.Net,MCPD.net)
www.netprosys.com

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-11-21 : 06:14:29

[code][code]
select t.type as Type,
sum(case when d.daytype = 1 then d.days end) as Day1
sum(case when d.daytype = 2 then d.days end) as Day2
from daysdetails d
left join typedetails t
on d.typeid = t.typeid
group by
t.type[/code][/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources