vinu512 (9/6/2012)

---

The following query should do it for you:

Select a.IssID, a.subject, a.dessc,

MAX(Case When c.new_value = 'Accept' Then b.created_on Else NULL End) As Accepted_Date,

MAX(Case When c.new_value = 'Assign' Then...

CREATE TABLE Iss

(

id BIGINT,

name Varchar(50)

)

CREATE TABLE Jou

(

id BIGINT,

iss_id BIGINT,

created_on DATETIME

)

CREATE TABLE Jd

(

id BIGINT,

jou_id BIGINT,

VARCHAR(10),

old_value varchar(10),

new_value varchar(10)

)

CREATE TABLE

(

id BIGINT,

name VARCHAR(50)

)

INSERT INTO (id, name) values (1,'Phase')

INSERT INTO (id, name)...

Greg Snidow (9/5/2012)

---

Maybe something like this...

CREATE TABLE dbo.YourNewTable

(

lssID INT IDENTITY(1,1),

[subject] VARCHAR(50),

[desc] VARCHAR(50),

Accepted_date DATE,

Assigned_date DATE

)

But seriously, what is the reason for this? If you turn...