I suppose if I sat down and started learning how to become a brain surgeon (being a software developer), 20 or 30 hours of studying would get me as far...

Just tried the XML version with a short test string.

SELECT * FROM dbo.Split(N'03680027,08563027,03682027,03677003,03683027,17948027,03702003,17948003,15636003,03620003,03299003,03014003,03679027,08563003,03013003,15636027,00781003,35879049,03682003,03683003,03679003,03680003,30441003,02747049,02748049,02749049,03300003,02981003,02981027,02981004,02982003,02982027,02982004,02983003,02983027,02983004,06921003,02974003,02974027,02974004,02975003,02975027,02975004,02973003,02973027,02973004', N',');

Looks really good. Seems to perform just as quickly as the one I use with the Tally...

Gatekeeper,

Thank you for the links.

-sandor

The answer I was looking for was "create 2 tables with error for third", that NOT being an option I chose incorrectly the "create 3 tables with error for third"....

Ignore this topic and refer to topic http://www.sqlservercentral.com/Forums/Topic1298365-3151-1.aspx?Update=1.

This is a very nice function. But, to even consider its use, it would be helpful to know how it compares in terms of execution performance to other similar functions...

Thank you! Both, the pivot and the XQuery solutions work.

After some deliberation I've ended up using the XQuery solution.

Main reason being that I am not a fan of the...

Thanks for the link. I did not come across this article, though I have been searching the Internet.

I'll read through this and get back on this topic.

Thank you for your help on this topic.

When I execute these statements:

declare @doc xml

set @doc = '<root><node_x0023_>some_value</node_x0023_></root>'

select @doc

I get the following result as the contents of the XML variable:

<root>

<node_x0023_>some_value</node_x0023_>

</root>

The conversion is not made. I was expecting...

.

Source control integration with various source control systems like Team Foundation directly from SSMS.

IBM technical support provided me with the solution.

Need to put curly braces around the stored procedure call for the IBMDASQL driver to return the result set.

Like this:

EXECUTE('{CALL DOUG.GETITEMUNITPRICE(?,?)}', @CustomerId, @ItemQtyPairs)...