Should we have a next level up from the seeder questions? It seems like it may be useful to have a next level up for those in the middle ground (2000-8000 rep). Maybe more levels?
Whilst I understand your intentions, I too don't see the benefit.
The seeder questions have a particular purpose to encourage some of the lesser rep, and somewhat more transient users to participate. Anything above that would only really serve to increase rep for everyone else and like Timothy says, thats not what they are here for.
Plus the extra overhead in managing those, and the idea of having 'rules' about who can answer what and when, would just damage the community that is building here.
Like I said, I think I get where you are coming from, but it's not needed.
I do not really see a strong value in it. Seeder questions are meant to help pull people in to the community and that is valuable in community building.
But I do not really see a strong reason to create something just to get people rep points. Most of the users here don't care about the rep once they get all the big features open (can't make comments or upvote until you hit a certain minimum). The people that really care about rep are probably better of working on really helping people then answering made up questions to build rep.
With that said, this is a good conversation for the community to have, so thank you for starting it.
I agree that there isn't a strong case for having a next 'class' of question...
But I do think that if you have some questions lined up, you should ask them anyway. I don't know about the other guys, but I tend to come away with a positive experience every time I ask a question, whether it's something that I think 'this could be useful to people' or whether it's something where I'm trying to balance my own thoughts.
So please don't be put off from asking :)
I say go for it. I see this as a knowledge sharing site and anything you come up with was probably rooted in an actual problem you have overcome. Anyone can answer at anytime, this will also benefit those who might encounter something similar EDIT: no need for another class--just use the seminal forfun tag!....I'll go first, why doesn't this work?
DECLARE @max int DECLARE @x int DECLARE @rows int --set up test data DECLARE @Phone TABLE (Number varchar(30),Extension varchar(30)) INSERT @Phone SELECT '+1 (401) 555-5555 cell','' UNION SELECT '(345) 7890 day only','' UNION SELECT '1-555-555-5555 x78','' UNION SELECT '(423) 674-5699 ext 45','' UNION SELECT '*457.987.6543','' SELECT @max = MAX(LEN(Number)) FROM @Phone SET @x = 1 WHILE @x <= @max BEGIN SET @rows = 1 WHILE @rows > 0 BEGIN UPDATE @Phone SET Number = Stuff(Number,@x,1,CASE WHEN (ISNUMERIC(SUBSTRING(Number,@x,1)) = 0 OR SUBSTRING(Number,@x,1) IN ('-','+','.',',')) AND SUBSTRING(Number,@x,1) <> 'x' THEN '' ELSE SUBSTRING(Number,@x,1) END) WHERE (ISNUMERIC(SUBSTRING(Number,@x,1)) = 0 OR SUBSTRING(Number,@x,1) IN ('-','+','.',',')) AND SUBSTRING(Number,@x,1) <> 'x' SET @rows = @@ROWCOUNT END SET @x = @x + 1 END -- remove 1 prefix UPDATE @Phone SET Number = CASE WHEN SUBSTRING(Number,1,1) = '1' THEN SUBSTRING(Number,2,50) ELSE Number END -- move extension to separate column UPDATE @Phone SET Extension = CASE WHEN CHARINDEX('x',Number,1) > 0 THEN SUBSTRING(Number,CHARINDEX('x',Number,1) + 1,50) ELSE NULL END UPDATE @Phone SET Number = CASE WHEN CHARINDEX('x',Number,1) > 0 THEN SUBSTRING(Number,1,CHARINDEX('x',Number,1) - 1) ELSE Number END SELECT * FROM @Phone
No one has followed this question yet.