No need for a loop and no need to cross post as it only fragments the solutions.

Further answers in this thread: http://www.sqlservercentral.com/Forums/Topic1655566-392-1.aspx

It could, but it won't be the same as the optimal plan.

This is one possibility:

WITH E(n) AS(

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL

SELECT...

I can't help you further if I only have a part of what you're doing.

Not a fan of this function as you might get performance problems, but maybe this is what you need.

RETURN CASE WHEN @TimeInMins = 0

THEN CONVERT(VARCHAR(2), LEFT(@RemainingSeconds,...

FWIW, imex's query will generate the same plan as yours but it's simpler to write.

Phil's might be better or not, you'll need to test it before you implement it.

For questions...

This article about dynamic pivots and cross tabs could help you.

http://www.sqlservercentral.com/articles/Crosstab/65048/

My guess (someone else might confirm it) is that the first needs to create a safe plan while the other one can create an optimized plan. The use of variables...

If you use a column in the where clause from a table joined by an outer join, your converting it to an inner join. Check the following alternative:

SELECT COUNT(a.PatientID) AS...

Sorry, my bad.

Thank you for the correction Michael and the note about not being desirable.

Technically, the compatibility level would be 90 and up, but your idea is correct.

Internally, it makes no difference. Both queries should create the same execution plan.

I...

David Burrows (1/27/2015)

---

As already pointed out your logic is flawed

e.g. One interpretation of the flawed logic is to find all combinations of VALUEA in both tables where they do not...

Would this work for you?

SELECT

well.wellide AS Prospect,

well.wellidc AS Pad,

well.wellname AS Well,

job.idrec AS JobID,

rig.contractor + ISNULL(' '+ rig.rigno,...

The primary key is usually the same as the clustered index but that's not a rule. They're both independent as the process to define them is different. The primary key...