Dishdy, mind reposting it or telling us how to find the solution in Challenge 39"?

Same as previous, changed cast to varchar(max) (instead of nvarchar(max))

Same as previous, changed cast to varchar(max) (instead of nvarchar(max))

Try this: IF OBJECT_ID('TC78','U') IS NOT NULL DROP TABLE TC78 GO CREATE TABLE TC78( ID INT IDENTITY, Field VARCHAR(MAX) ) GO INSERT INTO TC78(Field) SELECT '1-14x25x2pl; 1-14x20x2pl; 1-1

Dishdy: the query fails due to the use of nvarchar(max)? What is the default collation within the database and server you are using? I'm willing to bet it's non-Unicode. You are right.... should set MAXRECURSION 0 to handle more than the default 100

CTE_ParseEntries: Parses each row to separate each entry into an ID and Field value CTE_ParsedAndOrdered: Creates an Order value based on the PartNo section of the Field column. CTE_CalcRowAndOrder: Calculates a Row and Order value, useful for sets of

CTE_ParseEntries: Parses each row to separate each entry into an ID and Field value CTE_ParsedAndOrdered: Creates an Order value based on the PartNo section of the Field column. CTE_CalcRowAndOrder: Calculates a Row and Order value, useful for sets of

What are the word-breaking rules? In your example "Encyclopedia" is hyphenated. What are the rules to determine where a word can be broken?

Create header and detail data separately, but with common column names and data types. "Combine" them using the sorting rules Table 'TC72_Employees'. Scan count 2, logical reads 12, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physica