Try this:

DATEDIFF(minute, ExecutionLog.TimeStart, ExecutionLog.TimeEnd) AS TimeTaken

I think it would be possible to do this in a single query by using XQuery on the XML in the col2 column to extract the parameter values and recursive...

The expression can be simplified a little from

LAST_UPDATE > DATEADD(day, -1, DATEADD(day, DATEDIFF(day, -1, GETDATE()), -1))

AND

Last_update < DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

to

LAST_UPDATE >= DATEADD(day, DATEDIFF(day, 1, GETDATE()), 0)

AND

Last_update...

Sergiy,

I have to admit getting a bit carried away with this string manipulation problem. The only...

Actually

WHERE NOT (X.status = 'I' AND...

Incidently, avoiding the use of the NULLIF function in these queries does give a significant performance improvement. The following compares Jeff's query with a functionally equivalent query that does not...

Here are the 4 queries I used for the testing mentioned in my previous post. Unlike my original queries, they do return a row corresponding to every row in the...

Who can say if I'm right other than the OP, it depends on the OP's precise requirements.

OP does state the following which Jeff's query doesn't do.

I also want to grouped...

The following variation has a level of SELECT nesting that is one fewer, but gives the same results.

SELECT LEFT(I.name, I.P2 - 1), RIGHT(I.name, LEN(I.name) - CHARINDEX('.', I.name, I.P2 + 1))...

You haven't provided your table schema so I have used the following in my query below:

CREATE TABLE Items (

name varchar(100) NOT NULL

)

GO

INSERT INTO Items

SELECT 'IT'

UNION ALL SELECT 'IT.Control.Bing'

UNION...

Yep, my solution is essentially the same as Derek Dongray's, except that I use a derived table. Derek Dongray's solution is simpler and may be all you require, but mine...

If you need to retrieve those tblKandidaten records that have an associated tblK_Berufsziele record with Berufskuerzel = 'CIMP' AND another tblK_Berufsziele record with Berufskuerzel = 'INS', then the following should...

How about this.

SELECT X.group, X.status, X.countOfTickets

FROM (

select a.group, a.status, countOfTickets = count(b.tickets)

from group_tbl a

left outer join tickets_tbl b

...

Quite true, but that's not relevant here.

The concatenation problem...

If you have a Tally table, run this

SELECT P.lastwaittype, T.N, Code = ASCII(SUBSTRING(P.lastwaittype, T.N, 1))

FROM master.dbo.sysprocesses P

CROSS JOIN dbo.Tally T

WHERE P.spid = 51

My query results on a SQL Server...