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....

It depends. What...

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 ...

Michael Valentine Jones (1/26/2009)

---

Where do you see the 1,000,000 number?

At the bottom of the main Forums page I see this:

Board Statistics

760,819 members have posted 518,208 posts within 118,891 topics....

Jeffrey Williams (1/26/2009)

---

Lynn Pettis (1/26/2009)

---

Very carefully.

Using SSIS, the process would be encapsulated in a FOR EACH container (not exactly sure how i would configure) and within that I'd have the...