Can anyone help me to solve this issue ?

Thank you much, I will check the result for accuracy

Thanks for the reply,

According to given scenario I have time till end of June, % should be calculated by considering the scheduled date, Completed Date. In the row number 1...

Thank you so much, This is the perfect solution 🙂

Hats off

Sorry,

I replied back

Hi John

Still its not meet my requirement, i need only the total hours as result. In the below query i get the total hours but i am not able to...

Hi,

CREATE TABLE [dbo].[Temp2](

[SiteCode] [int] NULL,

[StatusTime] [datetime] NULL,

[Status] [char](2) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

insert into Temp2 values(111,'2016-05-30 12:30:00.000','A')

insert into Temp2 values(111,'2016-05-30 13:02:00.000','A')

insert into Temp2 values(111,'2016-05-30 14:02:00.000','I')

insert into Temp2 values(111,'2016-05-30 15:02:00.000','I')

insert into...

Hi John,

CREATE TABLE [dbo].[Temp2](

[SiteCode] [int] NULL,

[StatusTime] [datetime] NULL,

[Status] [char](2) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

insert into Temp2 values(111,'2016-05-30 12:30:00.000','A')

insert into Temp2 values(111,'2016-05-30 13:02:00.000','A')

insert into Temp2 values(111,'2016-05-30 14:02:00.000','I')

insert into Temp2 values(111,'2016-05-30 15:02:00.000','I')

insert...

Hi John

I tried many queries, Below is one of it. Its gives me the time difference of Max and Min value of statustime where Status = 'I' and i am...

Thank you so much salliven

Its worked,

Sure, Thanks for your response

Table : message_queue_details

ID MobileNumberMsgStatusSubmitDate ...