If I drop TOP 7 clause, it would list dates from 3/19 through 3/26.. a total of 8 days.

Thanks!

No they are gone. I do not have the solution file or the rdls. Just need to know who deleted them..

Thank you . It works as expected.

The sample of the desired result provided for ClosedTicketsTillDate is not correct.

OpenticketsTillDate works perfectly . Below is what I need for ClosedTicketsTillDate .

For Grp A , where create DAte =...

Got it. Thanks 🙂

It works for Scenario 2. In scenario 1, if there are two 'Error' status, I need to display the one with the MAX(EndTime)

INSERT INTO #NewTempTable (StartTime, EndTime, ServerName, Databasename, [STATUS])...

Thanks That worked!

This worked for me.

REPLACE(CONVERT(VARCHAR(20), CAST(ROUND(@i, 0) AS MONEY), 1), '.00', '') AS [Size]

Can anyone help me please ?

When joining #temptable T1 to #temptable T2 on T1.Project = T2.Project , AND T1.Product = T2.Product LEFT(T1.SNum ,5) = LEFT(T2.SNum ,5)

WHERE T.Product ='UC' AND T2.Product ='UC' AND LEN(T2.SNUM) >...

Thanks . It works!

Thanks That helped.

Thanks that worked perfectly!

That is correct.