Viewing 15 posts - 8,341 through 8,355 (of 19,564 total)
Gianluca Sartori (10/10/2011)
It depends! (You should have seen that coming :-P)
Though undocumented, as has been said, there is evidence of Microsoft calling their own "undocumented" code. I think it...
October 10, 2011 at 8:52 am
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...
October 7, 2011 at 2:54 pm
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...
October 7, 2011 at 2:47 pm
Jeff Moden (9/26/2011)
SQLRNNR (9/21/2011)
October 7, 2011 at 2:42 pm
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...
October 7, 2011 at 2:40 pm
Thanks for putting this together.
October 7, 2011 at 2:38 pm
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...
October 7, 2011 at 2:37 pm
I hope a bunch of people stop you. Are you going to wear a hawaiian shirt and a Kilt?
October 7, 2011 at 2:35 pm
paul_ramster (10/7/2011)
If you data isn't...
October 7, 2011 at 2:25 pm
LSAdvantage (10/7/2011)
Beautiful! Thank you very much Jason!
You are welcome. I would recommend making changes to the underlying schema in order to show ownership change or maybe previousowner such...
October 7, 2011 at 2:02 pm
drew.allen (10/7/2011)
October 7, 2011 at 2:01 pm
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,...
October 7, 2011 at 1:24 pm
What have you tried so far in order to achieve this?
October 7, 2011 at 12:54 pm
Viewing 15 posts - 8,341 through 8,355 (of 19,564 total)