Maybe instead of creating the cte in over 100 procs you could create a view. Then you just have to add a join in your other queries. This would give...

EamonSQL (8/1/2013)

---

Thanks for this.

The reason I know is that this is an old app which the vendor isn't supporting anymore.

Sometimes a data issue occurs and we've been told that a...

I can see some issues with what you have here. It starts with normalization. You really should only have 1 of those UserAccess values per row. I am guessing that...

That is because you didn't declare the variable. You are passing it to the...

Fire up sql profiler and run the app.

Curious, how do you know it is a stored proc?

madsovenielsen (8/1/2013)

---

Thanks for the quick reply.

Im getting the following error when using the query:

Msg 8120, Level 16, State 1, Line 1

Column 'VisWebHoldSkema.FagNavn' is invalid in the select list because it...

Excellent job posting the details. I just couldn't quite see what you were trying to do before.

Something like this should get what you want.

select UserId,

MAX(Case when Ugedag = 'Mandag'...

http://msdn.microsoft.com/en-us/library/ms173463.aspx

Glad you checked in. Was thinking yesterday that I hadn't seen...

Brandie I was just thinking about you a couple days ago when I saw that Shadowrun Returns has been released. Not sure if you are familiar with the old super...

dwain.c (7/31/2013)

---

I agree that clarification is needed on what is meant by "best fit." That's why I asked if 4,6 shouldn't be the correct answer and offered some suggestions...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Just a quick thought as I happened through here. Why do you have select top 100 percent in a subquery here? You have introduced a performance hit when it is...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

dwain.c (7/30/2013)

---

I love SQL bin-packing problems! Hate to disagree with you Sean but they don't need to be overly complicated.

Before I suggest a solution, shouldn't the answer be 4,...