Viewing 15 posts - 3,241 through 3,255 (of 3,957 total)
I just made the most awesome discovery while using cascading CROSS APPLYs so I thought I'd post it here.
Did you know that inside the CROSS APPLY if you refer to...
July 4, 2012 at 4:46 am
Gullimeel (7/3/2012)
Why do you need CTE because this is more of a specifc requirement and if you have 4 districts then it will exceed 6100...
July 3, 2012 at 10:32 pm
GilaMonster (7/3/2012)
For anyone not on/not paying attention to twitter.....It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
Heartiest of congratulations Gail!
Where's the party?
We could do it...
July 3, 2012 at 10:10 pm
dwain.c (7/3/2012)
It appears that I'm off the optimal solution because [9,26] (population 6013) are coming up in my ineligible list. If I can resolve that, I think I'll be...
July 3, 2012 at 10:06 pm
After revising my population range check to BETWEEN 5900 AND 6100, I now get results like this:
My latest is (single cascaded CTE):
1. 30 districts combined in 10 triplets
2. 22 districts...
July 3, 2012 at 9:51 pm
In your original spec you stated the population set requirement:
Les Cardwell (6/22/2012)
Sweden Challenge...
* Total 'old' number of Districts was 66.
* Total Sweden Population = 167,976.
* New District population set...
July 3, 2012 at 6:36 pm
Jonathan, Etopap and Gwade,
Thanks for your interest, as well as taking the time to read the article. Hopefully there's something useful for you.
Wanna see my charts of the cumulative...
July 3, 2012 at 6:29 pm
G Bryant McClellan (7/3/2012)
Excellent post, both for the concise definitions and the code explanations.For the Poisson distributions consider the use of a CLR. That my eliminate the side-effects issue.
Bryant,
There is...
July 3, 2012 at 6:28 pm
Sue Amin (7/3/2012)
July 3, 2012 at 6:24 pm
Lowell and Sean - If you big dogs thought this stuff was good enough for your toolboxes, obviously I have done something right!
About time too, as I've been adding stuff...
July 3, 2012 at 6:23 pm
dwain.c (7/2/2012)
1. 24 districts combined in 8 triplets
2. 20 districts combined in 10 doublets
3. 11 districts...
July 3, 2012 at 9:00 am
praneshram (7/3/2012)
Hi All,Thanks for all of your valuble suggestions and i will be using 'ChrisM@Work' Suggestion. Thanks for all of your valuable time.
+1 for ChrisM!
Gullimeel: Clearly my contribution was...
July 3, 2012 at 2:29 am
Let me share with you my current thought pattern to see if you have any comment.
I mentioned in my prior post (point #4) that "11 districts that cannot participate in...
July 3, 2012 at 2:24 am
Thought I'd give the OP's problem a shot so I came up with this.
;WITH CTE AS (
SELECT [Member ID], [Claim Number], [Date...
July 3, 2012 at 12:20 am
ChrisM@Work (7/2/2012)* You still have tables neoset_statisticsLocationTypesLangs and neoset_statisticsLocation_types_jt in your
FROM list, even though neither are referenced in the output, or by any joins, or the WHERE clause.
Removing...
July 2, 2012 at 11:56 pm
Viewing 15 posts - 3,241 through 3,255 (of 3,957 total)