You're better off using a CTE than the CROSS APPLY.

WITH ActiveUpdates AS (

SELECT [ID], SortOrder, isActive, ROW_NUMBER() OVER( ORDER BY SortOrder DESC, [ID] ) - 1 AS rn

FROM @CustomerConditions

)

UPDATE ActiveUpdates

SET...

dan-572483 (8/1/2012)

---

Interesting... I've always used "<value> IS NULL" having learned T-SQL from an application I supported. Using the default configuration "<value> = NULL" doesn't genertate an...

mandoswork (8/1/2012)

---

The normalisation is the whole point of the exercise. I'm trying to import a flat file, with the same columns repeated 10 times, into a more logical structure -...

A GROUP BY with CASE expressions is likely to perform better, because it requires fewer scans and logical reads of the base table.

SELECT Sales_CustomerID

FROM @sales1

GROUP BY Sales_CustomerID

HAVING COUNT(CASE WHEN Sales_Status...

Your DISTINCT clause is hiding the problem. ...

You're looking for tables name AuditRecCount, DocumentRecCount, and FileRecCount, but the tables are named AuditRecord, Document, and File respectively. Since the names don't match, there are no values to...

SSMS doesn't display the entire field. I think that it only displays 255 characters by default. If you are trying to view the contents of the variable in...

No, the DISTINCT masks the problem with the join creating false "duplicates" in the sum. The GROUP BY only masks this same problem in a different way. The...

Actually, it is....

I don't think that using DISTINCT is the correct way to solve this problem. DISTINCT will ignore ALL duplicate values, not just the ones caused by your join. ...

Lowell posted his script, so I don't need to find a link. I think his calculation for Julian Day can be simplified to DATEPART(dy, YourDateField), but you need an...

I don't think that your sample values are correct. June 22, 2012 is 102 days after Feb 3, 2012. If you only want to count paid days, are...

The site is blocked by my company.

Drew

First, I can't access that link. Second, a picture is not a useful way to post code, because we can't copy and paste it into SSMS to test it....

You could probably use the windowing functions with the SUM to get the desired output, but I've found that the windowing functions are not terribly efficient, so you're probably better...