Visibility of the same tablix (tab1,Tab2) is also controlled based on

1) if there are values for the result set

2) Select from parameter Tab1,Tab2 or both

If there are no rows...

Actually I want multi value Tab1,Tab2 or select Both (multi-value) . This way I can eliminate All .

If you don't mind can you send an update query instead of the select ?

Thanks,

PSB

The query performance is very poor . Any tips on improving performance ?

Thanks . Works perfectly.

Any help , please anyone ?

Thanks . I worked perfectly.

Any help will be greatly appreciated.

Thanks,

PSB

Thanks that worked perfectly.

Thanks!

Hi,

Some of the values are also 14 digit . If I use your code below , it returns incorrect dates as shown below.

declare @TimeMS bigint = 61353491400000;

select

[Date/Time] =

-- Verify time...

Need to find the following:

Open 1st Action :

-Min, Max, and Average time from Order open to first response

Close 1st Action:

-Min, Max, and Average time from Order open to closure

--------------------------------------------------------------------------

Open 1st...

If the Order has not been completed yet then it shows as 1969-12-31 19:00:00.000 or much older dates..

CREATE TABLE #Order

(

OrderID INT,

DateCreated DATETIME,

DateCompleted DATETIME,

NotificationID INT,

NotDaTE DATETIME,

RecipientID INT,

NotificationType VARCHAR(20)

)

INSERT INTO #Order (OrderID,DateCreated,DateCompleted,NotificationID,NotDaTE,RecipientID,NotificationType)

SELECT 93207,'5/22/2014 08:16:03.000','5/23/2014 10:52.000',601780,'5/22/2014 10:16:19.000',48603,'REQREPLY'

UNION

SELECT 93207,'5/22/2014 08:16:03.000', '5/23/2014 10:52.000', 601779,'5/22/2014 10:16:20.000',16242,'REQTECH'

UNION

SELECT 93207,'5/22/2014 08:16:03.000','5/23/2014 10:52.000',601778,'5/22/2014 10:16:50.000',637,'REQ_IN_QUEUE'

UNION

SELECT...

Thanks for the solution! it works perfectly .