Though undocumented, as has been said, there is evidence of Microsoft calling their own "undocumented" code. I think it...

plan

Thanks for the question.

Faster would be to use the Split function by Jeff Moden already mentioned or to use a CLR splitter that you can find in the discussion on the link provided...

I think I'd go with SSIS as well in this case.

How much memory (RAM) do you have? The message indicates that either your RAM or your Video Card memory...

Jeff Moden (9/26/2011)

---

SQLRNNR (9/21/2011)

---

I really want to be there. Not too terribly sure I will make it. I have registered for Summit - but I have other family...

create another procedure that can execute the proc in question via a loop.

You can allow this new proc to accept the delimited list and then parse that list into rows...

Thanks for putting this together.

Planned test - about once a year.

In some companies though we have had to use it once a quarter due to various things.

I read once upon a time that an...

I hope a bunch of people stop you. Are you going to wear a hawaiian shirt and a Kilt?

paul_ramster (10/7/2011)

---

Performance may be poor on larger datasets, because the solution is a Triangular Join or "Hidden RBAR". For more information, see the link in SQLRNNR/Jason's signature!

If you data isn't...

You are welcome. I would recommend making changes to the underlying schema in order to show ownership change or maybe previousowner such...

drew.allen (10/7/2011)

---

Your PARTITION BY is wrong. You want the last record for each Service_Tag, so the PARTITION BY should just be on the Service_Tag, and not on the Service_Tag,...

This should work for you

; with Dupes as

(select DISTINCT AH1.EmployeeID, AH1.ServiceTag, AH1.FirstName, AH1.LastName, AH1.Location, AH1.LastUpdateDate

,AH2.EmployeeID AS PreviousOwner

--,RowNo = ROW_NUMBER() over (partition by AH1.EmployeeID,...

What have you tried so far in order to achieve this?