Viewing 15 posts - 1,291 through 1,305 (of 5,590 total)
Sounds like you're ready to roll. Glad you got it working, and very glad that you're understanding what's going on.
May 25, 2011 at 3:40 pm
mark hutchinson (5/25/2011)
it depends on the ability to split the max string at a delimiter into <8000 sized chunks reliably. Otherwise, the ends of the parsed strings sets would...
May 25, 2011 at 2:02 pm
Jeff Moden (5/25/2011)
Besides... everyone knows to use a CLR for these type of things, right. :-P:-P:-P:hehe:
Yes, I know. But, when you're selling software solutions, you can't mandate their use to...
May 25, 2011 at 1:58 pm
mark hutchinson (5/25/2011)
Here's an idea to kick around for varchar(max) data...use a tally table (or cte equivalent) to split the very large string into strings less than 8000 characters and...
May 25, 2011 at 12:35 pm
Ninja's_RGR'us (5/25/2011)
WayneS (5/25/2011)
Ninja's_RGR'us (5/25/2011)
jshurak (5/25/2011)
nvm, i'm an idiot. I need some coffeeI think this means that he figured out the problem... like include all columns in the insert!
Or at...
May 25, 2011 at 10:45 am
Koen Reijns (5/25/2011)
Hi Wayne,This seems to do exactly what I wanted to reach.
I will perform some more testing tomorrow with real results from the query but it looks ok.
Great. Do...
May 25, 2011 at 10:41 am
Ninja's_RGR'us (5/25/2011)
jshurak (5/25/2011)
nvm, i'm an idiot. I need some coffeeI think this means that he figured out the problem... like include all columns in the insert!
Or at least the...
May 25, 2011 at 10:37 am
fahey.jonathan (5/25/2011)
Is there a reason why you chose a VARCHAR(8000) instead of a VARCHAR(MAX)?
Performance. It goes wacko as soon as you start sending in > 8000 characters to the function....
May 25, 2011 at 10:02 am
This code produces the results in my prior post.
Comments in the code.
;
WITH cte AS
(
-- Get the difference between the row number (ordered by discount id)
-- and the row number...
May 25, 2011 at 9:53 am
Ok. Then you would actually want your results to be like this? (Changes in bold)
DISCOUNT_ID MIN_AGE MAX_AGE MIN_FULLPAYERS FROM ...
May 25, 2011 at 9:41 am
You want these processed "sequentially"? so that for DiscountIDs 5-9, when #7 has the different MIN_FULLPAYERS, it starts the evaluating over again, and then #8-9 are not considered part of...
May 25, 2011 at 9:19 am
In your results, where do the DISCOUNT_ID values of 10/11 come from?
May 25, 2011 at 9:07 am
IMHO (5/25/2011)
May 25, 2011 at 7:56 am
GilaMonster (5/24/2011)
Steve Jones - SSC Editor (5/24/2011)
Stefan Krzywicki (5/24/2011)
Plus, if the person gets undercover help and succeeds, they're going to be asked to do more that they're going to need...
May 25, 2011 at 7:08 am
whoops... opc.three has it covered.
May 24, 2011 at 7:36 pm
Viewing 15 posts - 1,291 through 1,305 (of 5,590 total)