Ooops! Silly me, I just realized why that won't work. Try this (assuming this is what Sean meant):

WITH SampleData (Origin, Destination) AS

(

SELECT 1, 2

UNION ALL SELECT 2, 1

UNION...

Sean Lange (2/17/2014)

---

Can you provide some ddl and sample data? It sounds like your origin and destination columns are derived? If your pattern of data is consistent maybe you can...

Are you looking for a weighted average (by day within date range) for the average exchange rate?

Ed Wagner (2/17/2014)

---

dwain.c (2/16/2014)

---

Ed Wagner (2/13/2014)

---

dwain.c (2/13/2014)

---

I guess it is...

You might try putting the WHERE clause before ORDER BY instead of where you have it (the subquery that determines the TOP n rows in your Tally table).

I've got a million of 'em.

THE SEX LIFE OF AN ELECTRON (with unhappy ending)

One...

OK I'll bite. What's a Numbers...

Here are 2 more ways:

WITH PreAggregate AS

(

SELECT Symbol, ExpDate

FROM #temp1

WHERE ExpDate > '2014-03'

)

UPDATE a

SET Tag = 1

FROM #temp1...

If you really need to eke every last erg of performance out of a replace, consider using a binary collation:

https://connect.microsoft.com/SQLServer/feedback/details/512459/replace-function-extremely-slow-with-non-binary-windows-collation

I have 2 questions:

1. Where is the subquery? I see a derived table.

2. Are you sure you want to use NOLOCK? There's a lot of potential gotchas in...

If you don't have a numbers table at your disposal like Jason does, this will also work.

DECLARE @sometab TABLE (Person INT, [Date] DATE, [Hours] DECIMAL(12,2))

INSERT INTO @sometab

...

Note that in your data setup 1-2-2013 translates to Jan 2 2013, but otherwise this should do it for you.

SELECT name1, name2, name3 -- , b.*

,[Jan-13]=MAX(CASE...

Ed Wagner (2/13/2014)

---

dwain.c (2/13/2014)

---

I guess it is fortunate then that...

I guess it is fortunate then that most of the...

Here it is deleting multiple LineIDs from multiple TIDs and then renumbering.

WITH RowsToDelete (TID, LineID) AS

(

SELECT 100, 3 UNION ALL SELECT 200, 2 UNION ALL SELECT...