Thanks for suggestions but still no luck I'm afraid. The same number of rows are being returned.

'DataValue' is initially being casted to decimal and then to integer, as nvarchar(max)...

'DataValue' comes from the table 'dbo.DataItem', which is nvarchar(max), but I am explicitly casting 'DataValue' to integer in the view. I have used the ISNUMERIC function to verify that...

Thanks Scott.

Fixed it... I've inserted the output into a table variable.

Thanks.

Thanks opc.three. I will test.

Thanks Michael. Much appreciated 🙂

Thanks all for your inputs. Much appreciated 🙂

SwePeso (2/8/2011)

DECLARE @Sample VARCHAR(100) = '12345'

;WITH cte(CurrPos, LastPos, String)

AS (

SELECT1 AS CurrPos,

DATALENGTH(@Sample) AS LastPos,

CAST(@Sample AS VARCHAR(MAX)) AS String

UNION ALL

SELECTCurrPos + 1 AS CurrPos,

LastPos,

STUFF(String, 2 * CurrPos, 0, ',') AS String

FROMcte

WHERECurrPos...

No problem, largely thanks to your article on tally tables which I read just last week 🙂

If my understanding is correct then this method uses a tally table in conjunction with the SUBSTRING function to get the starting positions of each character in @string, and prefix...

That's pretty slick! Thanks guys.

Thanks getoffmyfoot, I agree with your solution. The only problem that I can see with this is how the reports will be displayed when using different screen resolutions, however I...

Hi,

I am having the same problem, has anyone come up with a solution for this yet? I am using SQL Server 2008 R2.

I tried adding the following code to...

Thanks all for the advice so far. I will download the evaluation version and give that a go.

That's it. Thanks very much.