Since you're talking about a dynamic PIVOT I assume you're familiar with dynamic T-SQL syntax.

Therefore, I recommend to have a look at the DynamicCrossTab link referenced in my signature. It...

PaulB-TheOneAndOnly (5/7/2010)

---

Once table...

Oh, I need to add one more question: how accurate do you need to calculate the distance? Or, in other words: What is the largest distance you're dealing with?

I strongly vote against that proposal!

Alternatively I would recommend to tune the on-the-fly solution.

Just because the current solution has performance issues does not imply in any way that there is...

How does the table structure looks like (including sample data)?

What do you consider as a "sent message"?

Example: I send a mail to 10 people using a single mail and miltiple...

No, it's not...

Ok, here's a coded version based on the link Jason provided:

DECLARE

@ClientCode INT,

@cumReturn NUMERIC(18,4)

SET @ClientCode=0

SET @cumReturn=0

UPDATE #Scores

SET

@cumReturn=

CumulativeReturn=

CASE

WHEN @ClientCode=ClientCode

THEN @cumReturn * (100 + ReturnPercent)/100

ELSE CumulativeReturn

END,

@ClientCode = clientcode

FROM...

WayneS (5/5/2010)

---

Yes, it would. Which reminds me... are you writing one based upon that post last year where you found...

Glad I could help 🙂

WayneS (5/5/2010)

---

lmu92 (5/5/2010)

---

I would rather recommend you to modify the related sp's not to use DATEPART() anymore. Instead of using DATEPART(dw,...) you could use DATEDIFF(dd,'19000101',YourDate)%7. This will ALWAYS return 0...

keent (5/5/2010)

---

Excellent point. I may have to add a line to set that on all of my stored procedures just for safety. We are a small shop and I am...

Do you know how...

One of the most interesting methods to connect to a list of files in a folder with (almost) pure SQL has been posted by Lowell here .

Once you have...

kbnyny (5/5/2010)

---

why is this statement not working:

select t1.ACTNUMBR_1, t1.ACTNUMBR_4, t1.ACTINDX, t1.CREATDDT

from C1.dbo.AN00100 t1 union all

select t2.ACTNUMBR_1, t2.ACTNUMBR_4, t2.ACTINDX, t2.CREATDDT

from C2.dbo.AN00100 t2 union all

select t3.ACTNUMBR_1, t3.ACTNUMBR_4, t3.ACTINDX, t3.CREATDDT

from C3.dbo.AN00100 t3

WHERE...

When you do your testing, try the following:

before running your query, add

SET DATEFIRST 1 -- set the first day of a week = Monday

The result of your query might be...