Viewing 15 posts - 2,581 through 2,595 (of 8,416 total)
Jeff Moden (9/22/2010)
The problem with the Tally Table related splits is that I forgot :blush: to add 1 to the length....WHERE N BETWEEN 1 AND LEN(@Parameter)+1
Indeed. Even...
September 22, 2010 at 8:47 am
Jeff Moden (9/22/2010)
Heh... Of course it doesn't handle Unicode correctly... the variables are all VARCHAR.
That's a bit circular! It doesn't handle Unicode because it doesn't? 😛
The parameters are indeed...
September 22, 2010 at 8:37 am
Shawn Melton (9/22/2010)
Paul White NZ (9/21/2010)
How do you surprise an index?Unique up on it.
(Rob Farley)
OK...I laughed at that one.
I heard it for the first time about a week ago, and...
September 22, 2010 at 7:14 am
steve-893342 (9/22/2010)
6 rows returned eh. Looks like my persistence paid off after all:-) http://www.sqlservercentral.com/Forums/FindPost979750.aspx
Yes indeed - and you still owe me a pint 😎
September 22, 2010 at 7:08 am
steve-893342 (9/19/2010)
Good one:-)I shall remember that for next time I need to bcp and split at the same time;-)
:laugh: Well there is some reasoning behind the example that might interest...
September 22, 2010 at 3:10 am
Brad Schulz (9/20/2010)
September 22, 2010 at 1:32 am
This seems a good time to highlight some other issues too:
The Tally solution does not handle trailing blank records or Unicode characters correctly:
DECLARE @CSV NVARCHAR(MAX) = N'A,B&C,,C,?,',
...
September 22, 2010 at 1:10 am
I must admit I'm a little confused about the conclusions being drawn overall.
At the risk of stating the obvious, using a multi-statement TVF is exactly equivalent to splitting the input...
September 22, 2010 at 12:56 am
abcim (9/21/2010)
Is you saying some thing like this to widen index...
No. Gail's suggestion was to use an included column, and I mentioned the alternative of a unique index....
September 21, 2010 at 11:48 pm
How do you surprise an index?
Unique up on it.
(Rob Farley)
September 21, 2010 at 10:27 pm
Cliff Jones (9/16/2010)
This is an outstanding series, thanks Paul for sharing this information.
Thank you very much, Cliff.
September 21, 2010 at 9:23 am
jcrawf02 (9/21/2010)
I'm with Bob on this one, not sure I fully understand all the requests, but the ones I got look useful to me.
Look useful and interesting, for sure, but...
September 21, 2010 at 8:56 am
Stefan Krzywicki (9/21/2010)
September 21, 2010 at 8:36 am
abcim (9/21/2010)
How to widen index?
If you need help with the syntax, please post the current definition of the index (you didn't include it before) and someone will help you. ...
September 21, 2010 at 7:44 am
Viewing 15 posts - 2,581 through 2,595 (of 8,416 total)