The first way I can think of to even come close to emulating this behavior in SQL Server is to use REPLACE() to remove any characters that are NOT in...

There are many ways to approach this. 🙂

If foo returns more than fob, you could try turning my inner join into a left outer join. That will give you NULL...

You have a lot going on here. I'll attempt to fix your code.

A little CTE magic, a little bit of join, some group by clarification, and voila!:

with foo as (

--GET...

You can only have one FROM in your query. I believe you'll want your SUM(Overig) up above the first FROM. You may have to do SUM(fob.Overig) as well.

You can simulate this with dynamic SQL - it's messy, but it works.

with Desired_Columns as (

select s.name as SchemaName

, t.name as TableName

...

You're pretty much looking at some kind of control table for that purpose, unless you have some way of controlling it in the application. Triggers won't work for this due...

What I'll sometimes use as a poor man's tally table (we don't have one) is to combine ROW_NUMBER() and TOP from some existing table that has enough records to do...

The nice thing about INCLUDE is that it doesn't matter what order the included columns are in. You could spend a long time tweaking your index based on logical reads......

In addition to the above advice, you should check out http://statisticsparser.com, which will summarize the output for you. It's really handy for when you're using statistics IO to check you...

The solution to this is messy, but not too technically difficult.

select Username

, case

when (select max(choice) from (

...

Hmm... I think I've finally got this one figured out (my initial thought of EXISTS would be been much messier!). Let's see:

-- First, find out how many qualifications

-- a given...

I think this would be a good place to make use of EXISTS.

For B, should there be an EmployeeID in there?

There are so many variables to this that it's hard to know where to start.

Different server hardware? Differences in Max Degree of Parallelism/Cost Threshold for Parallelism? Are your statistics being...

Eirikur Eiriksson (10/26/2014)

---

Quick note, if the ROW_NUMBER function has a satisfying index to work on it is not expensive at all, consider the code below which only does one index...

It sounds to me like you're looking for cases where you have rows with both values for that given date? Here's how I would do that:

SELECT

...