Fastest way to split delimited string in SQL Server

Source : http://www.sqlservercentral.com

/* 
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
SET NOCOUNT ON;

SELECT [Value] FROM [dbo].[split_delimited_string]
   ('1||2||3||4||5||6||7||8||9||10||11||12||13||14||15||16||17||18||19||20','||')
      WHERE Value IN (1,2,3,4,5,6,7,8,9,20)
SELECT [Value] FROM [dbo].[split_delimited_string]
   ('1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20',';') 

SET STATISTICS IO OFF;

Technorati Tags: SQL,SQL Script,Script

SET STATISTICS TIME OFF;
SET NOCOUNT OFF;
*/ 
CREATE FUNCTION [split_delimited_string] 
( 
@str NVARCHAR(MAX),  
@sep NVARCHAR(MAX) 
) 
RETURNS @value TABLE (Value NVARCHAR(MAX)) 
AS 
BEGIN 
DECLARE @xml XML
set @xml = (SELECT CONVERT(XML,'<r>' + REPLACE(@str,@sep,'</r><r>') + '</r>'))
INSERT INTO @value(Value)
SELECT t.value('.','NVARCHAR(MAX)')
FROM @xml.nodes('/r') AS x(t)
RETURN; 
END

Microsoft Dynamics GP Extender Discontinuation Announcement

Source : Microsoft

Effective February 1, 2013, the Extender Standard module for Microsoft Dynamics GP (Extender) will no longer be offered by Microsoft and all associated SKUs will be removed from the
Microsoft Dynamics GP price lists.

eOne Solutions (eOne) will continue to support the existing Extender customers. New or existing customers who wish to purchase Extender can purchase them directly from eOne.
Microsoft will not make Microsoft Dynamics GP Extender available on the Microsoft Dynamics GP 2013 price list. Customers will need to work directly with eOne to obtain Extender for
Microsoft Dynamics GP 2013. Starting February 1, 2013, Microsoft Dynamics GP customers who previously obtained licenses to Extender via the Microsoft Dynamics GP price list will
receive a reduction in the Protected List Price and will not be charged Business Ready Enhancement Plan (BREP) fees for Extender on their next BREP renewal date.
The license keys for these modules will remain on existing customers’ accounts, allowing the continued use of the modules.
This announcement provides partners with the 120-days’ notice required pursuant to the Solution Provider Agreement (SPA).

For more info on the same click here