I've not got time to go over it and make sure all of the syntax is correct, but this is the general idea: -

ALTER PROCEDURE [dbo].[Rep_Urlaubstage] (

-- Add the...

My whole post was a link to the article[/url] describing it. The article includes the code.

To get it out of the way, Text is deprecated so you shouldn't really be using it.

To answer your issue, cast it as VARCHAR(MAX) before doing your substring.

e.g.

SELECT SUBSTRING(CAST([Message] AS...

What data-type is [Message] ?

Try Jeff Moden's string splitter function, by far the fastest purely...

I'd be surprised if it makes an improvement.

Without DDL, sample data and expected results, all I'm going to do is directly convert your temp tables into CTEs. If you...

Anything wrong with using a variable as a holder?

e.g.

DECLARE @holderValue VARCHAR(MAX)

PRINT REPLICATE('-', 80)

SET STATISTICS IO ON

SET STATISTICS TIME ON

SELECT @holderValue = number /*use primary key*/

FROM master..spt_values

WHERE type = 'P'

PRINT REPLICATE('-',...

manjuke (2/9/2012)

---

Well you could try something like this..

DECLARE @xml AS XML = (

SELECT @id AS '@id',@name AS '@name',@onclick AS '@onclick',(

SELECT TOP 100 PERCENT A.* FROM(

SELECT '0' AS '@value', NULL...

Here's a hint. . . read this article and...

SELECT @cols = STUFF((SELECT '],''0'' [' + RTRIM(CPA.n)

FROM...

No. There is too much guess work involved, which is why she asked you...

I'd have probably done it like this

DECLARE @cols NVARCHAR(max) DECLARE @number INT

SET @number = 9

SELECT @cols = STUFF((SELECT '],''0'' [' + RTRIM(CPA.n)

...

Cadavre (2/8/2012)

---

cdh-727733 (2/8/2012)

---

No but they are linked to the children of 13, or the grandchildren of 11.

Essentially I am trying to achieve the drill down effect so as long as...

cdh-727733 (2/8/2012)

---

No but they are linked to the children of 13, or the grandchildren of 11.

Essentially I am trying to achieve the drill down effect so as long as there...

cdh-727733 (2/8/2012)

---

Ah yeah that was hard coded when I was testing!

I still can't get it though to step through :

Screwdrivers > Phillips / Slotted > Big / Small

Using your execution...