Without an ORDER BY, TOP is meaningless:

SELECT

t1.col1,

col2 = ISNULL(t1.col2, x.col2)

FROM @T t1

OUTER APPLY (

SELECT TOP 1

t2.col2

FROM @T t2

WHERE t2.col1 > t1.col1

AND t2.col2 IS NOT NULL...

Recursion is the third fastest; CLR > "Quirky Update" > rCTE > cursor > triangular join....

Without a sample data script to work with? Figure out the algorithm for generating the numbers in the seq column, filtering...

Have a look at Peter Larsson's Composable DML blog entry.

This weekend is the Tewkesbury Medieval Festival[/url] where our band of brothers...

JayWinter (7/12/2012)

---

In this case SKU and UPC are the same and therefore its usage is correct. However my challenge is that there may be more than 1 record that meets...

JayWinter (7/12/2012)

---

Is the statement below correct?

I.SKU will be used to retrieve a record from from ITEMMAST when either J.SKU=I.SKU or J.ITEMUPC=I.SKU

FROM

Evy_RH_Objects.dbo.RETAIL_SALES I

INNER JOIN RH2007_EvyLive.dbo.ITEMMAST J on...

Evil Kraig F (7/12/2012)

---

A request to the threadizens, please don't pile on TeraByteMe if you happen across our little spat, at least not on my behalf. If it continues...

Next, put repeated correlated subqueries into the FROM list as OUTER APPLY. What's left is fairly straightforward except for the remaining correlated subqueries in the output;

DECLARE @strBE NVARCHAR(4)

SET @strBE ='1000'

...

Jeff's nailed all the reasons for rewriting this query from scratch, and I agree, chuck it away and start again. However, sometimes you can gain from having a baseline in...

debris_flow (7/6/2012)

---

Imagine a table which contains records for all weekly number of bugs

discovered by each QA analysts in the team for one year. Please describe a

simple SQL statement for identifying...

Shcherbunov Neil (7/6/2012)

---

My guess - this statement bears the stamp of truth. If...

coronaride (7/3/2012)

---

What do you mean when you say "enforced?" No, the clustered index is not unique.

I think I may see what you're getting at. Are you saying that when...

coronaride (7/3/2012)

---

I thought that the ONLINE specifiers were for indexes only. I'm only talking about a constraint. There's already a clustered index on the table and I don't want to...

coronaride (7/3/2012)

---

To be perfectly honest, I'm astounded with the responses I've gotten. Most people don't seem to know that there's a difference between an index and a primary key constraint....