Hi All
I try to create select
select distinct
TestNo
,LName+', '+FName Name
,case when (p.Status_Id)=20 then (p.StatusDate)
when (p.Status_Id)=28 then (p.StatusDate) end Test_Date
,p.Status_Id
from dbo.Request m
join (select p1.*
From dbo.Statuses p1
join (Select p2.Request_id, StatusDate
From dbo.Statuses p2) mp
on p1.Request_Id = mp.Request_Id) p
on m.Request_Id = p.Request_Id
It works but I would like to have 2 column for StatusDate in that select:
if Status_Id = 20 StatusDate column should be Test1
if Status_Id = 28 StatusDate column should be Test2
How it to do?
Thanks.
specify column field by condition
Posted - 10/12/2012 : 15:35:46
