question

CirqueDeSQLeil avatar image
CirqueDeSQLeil asked

Next step up from Seeder

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?

meta-asksscfor-fun
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image
TimothyAWiseman answered

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.

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nice comments. I was thinking of it as a way to help people stay involved. Sometimes there is a lull and people re-prioritize. But I see the point in not having it as well.
0 Likes 0 ·
Yes, sometimes there are lulls, and Matt in particular tends to answer questions really fast after they appear. But I think that is just part of the community. I personally don't see a whole lot of value in essentially making up questions to fill that lull.
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered

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 :)

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Scot Hauder avatar image
Scot Hauder answered

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
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yes I know the answer
0 Likes 0 ·
Good point - I'll keep using the for-fun tag!!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.