I really can't think of many cases where this would be necessary. Breaking into your home or vault is a time limited extraction. They want to delay...

The problem seems to be with the VALUES table value constructer

Replace your foj to derived table with this ...

full outer join

(SELECT 'dbo' name) b on a.name = b.name

.... and...

Giving the question the title of "deterministic" is a bit of a giveaway.

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

First, I'd be remiss if I didn't comment on the (nolock). That is almost certainly a bad idea

Anyway, you want something like:

WITH a AS (

SELECT

dhi.[GUID],

dhi.[timestamp],

la.[bundle_id],

dhi.[value]

...

Can you at least explain why you are so sure that this subquery is the main performance problem?

You haven't given us a lot to go on, and any way we...

Very nice. Glad I tried running it before spending any time trying to break the query down.

My favourite part of re-watching early (not always) first episodes of old shows is finding actors in bit parts that I have seen in bigger roles since.

For instance, Dennis Haysbert...

I think there is merit in an apprenticeship style approach. Anything that gets people more exposure to actual work environments, real-life problems, and how real life workplaces and...

-- Do some magic

Sorry for the delay, I've been off on vacation for a couple weeks

Try the following:

eclare @query nvarchar(max);

-- build small inline tally table

WITH E(N) AS(

SELECT...

I added data to your sample to make it easier to show the filtering

Basically, we get what you want with a CASE inside the SUM

This gets each employee and their...

Right. And you are saying that...

dwilliscp (3/11/2015)

---

For some reason it is trying to convert my data type to a number... one is varchar and the second is an ID field.

, CASE @Sort_Sel

WHEN 'Resource' THEN R.RESCODE

ELSE...

So what is in the MigrationExceptions table for the identifier you think should have been there, and have you tried joining that to the lookup table with a similar top...