I am a little confused on your post(s)...but that maybe a language issue.

you speak about a "resultant" table...can you clarify is this the actual db table you require to be...

many thanks

Ed Klein-385786 (6/3/2016)

---

This is an example of why every developer and especially every project manager should be required to read "The Mythical Man-Month" by Fred Brooks, subtitled Essays On Software...

have you considered using "CASE WHEN...THEN...ELSE...END"

yb751 (6/1/2016)

---

Ok so after a few voodoo spells and a couple chickens later I came up with this. If it looks weird, that's because it is. I'm pretty...

desired results for you

+-----------------------------------------------------------------------------------------------------------------------+

¦ DESIRED QUERY RESULTS ...

hehe....pity the OP didnt post an update when (s)he peeked out from behind the sofa, half...

some more testdata to play with

CREATE TABLE #yourtable(

id INTEGER NOT NULL

,alert_code ...

as an example of how to present some sample data see below and here https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

CREATE TABLE #yourtable(

id ...

any reason why no Tally or functions?

should the code have been

CREATE TABLE Mytest (id XML, x XML)

shagil.a.gopinath (5/31/2016)

---

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...

I gave response on your other thread.....please dont double post

http://www.sqlservercentral.com/Forums/FindPost1790784.aspx

I trust you understand that DATEDIFF returns the count of the specified datepart boundaries crossed between the specified startdate and enddate.

eg...even though the start and end times below are only...

Onthe assumption (dangerous I know!) that the inactive records always appear as two consecutive rows when ordered by site/datetime then the following mayhelp

CREATE TABLE [dbo].[Temp2](

[SiteCode] [int] NULL,

[StatusTime] [datetime] NULL,

[Status] [char](2)...