And I'm forgetting my manners. Thank you, it makes...

I received a private message with a question regarding my article that I can't answer, so I thought I'd put it here with the hopes that some of the gurus...

noeld (1/27/2009)

---

I liked your article ( a lot ) and it seems that you put a lot of effort into it.

My view of running totals is simple. It is a...

Smendle (1/27/2009)

---

I wish I had a true single processor system (no hyper threading or multiple cores) to have tested this on to see how it worked. Would I have...

The last two articles linked in my signature block may be of help. Give them a quick read and let me know if they do.

peter (1/27/2009)

---

Not having access to a developer or Enterprise version of SQL Server I find this topic hard to go into myself. Some of the SQL features used are only...

John Walker (1/27/2009)

---

I think Jeff hinted that he was going to eventually get to the analytics solution and far be it from me to steal his thunder, but I couldn't...

Simple answer, no. It isn't needed on the 64-bit OS as it handles memory differently than the 32-bit OS.

First question, why? The position of the data in the row is immaterial. Second, using a script no. You'd have to create a new table with the...

sqlcool (1/26/2009)

---

Hi there

Could u pls help to achieve this.

i need top version on each id as a result

ORIGINAL DATA

id version

1 ...

hmmm, over-think question we are. IDENTITY_INSERT is the heart of the question, not design of the tables.

Think, actually a GROUP BY with MAX in SELECT, hmmm

We can help you out if you provide a sample data set and the expected results based on the sample data set. Your expected results you did post seems...

hmmm, yes. Simple ones too easy to just give away.

Why would you say that? The number of members that have posted on the forums is much lower than the total number of members shown on the home page....