Viewing 15 posts - 16 through 30 (of 36 total)
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)...
April 28, 2011 at 6:35 am
'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...
April 28, 2011 at 5:45 am
Fixed it... I've inserted the output into a table variable.
Thanks.
April 14, 2011 at 7:43 am
Thanks opc.three. I will test.
March 21, 2011 at 10:47 am
Thanks Michael. Much appreciated 🙂
March 21, 2011 at 10:40 am
Thanks all for your inputs. Much appreciated 🙂
February 9, 2011 at 6:53 am
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...
February 8, 2011 at 7:17 am
No problem, largely thanks to your article on tally tables which I read just last week 🙂
February 7, 2011 at 9:31 am
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...
February 7, 2011 at 7:47 am
That's pretty slick! Thanks guys.
February 7, 2011 at 4:41 am
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...
November 17, 2010 at 9:17 am
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...
November 17, 2010 at 8:29 am
Thanks all for the advice so far. I will download the evaluation version and give that a go.
May 6, 2010 at 9:48 am
That's it. Thanks very much.
March 11, 2009 at 4:05 am
Viewing 15 posts - 16 through 30 (of 36 total)