« Maintaining your SQL Server 2000 DTS Package in SQL Server 2005 | Main | Reporting Services Reports from SharePoint Lists »
May 17, 2007
Update to Split Function
The Split function under "Using Multi-Value Parameters in Stored Procedures" has been used by several database developers. A collation issue occurred recently.The fix is changing the RETURN statement as follows:
RETURNS @IDTable TABLE (Item NVARCHAR(50) collate database_default )
Posted by Steve Mann at May 17, 2007 1:36 PM
Twitter 
LinkedIn 
YouTube