SP

Question

Post reply

SP

Viewing 15 posts - 16 through 30 (of 30 total)

You must be logged in to reply to this topic. Login to reply

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 1

paul s-306273 (4/26/2012)
This article was posted in 2005 on TechRepublic:

I knew I had seen that before!! :ermm: cheers guys

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 2

good question!!! thanks!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 3

I have rewritten the explanation. Thanks for pointing out the issue.

I have also contacted the author.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Toreador SSChampion Points: 11299 More actions · Answer 4

Edit: The following is mainly nonsense, but I've left it in so that subsequent replies make sense 🙂

some harsh responses IMHO. Who knows whether the author made use of a bit of code from the internet 7 years ago and forgot the source, or maybe one of his co-workers copied it and it's been around on their database for the last few years?

If I were to post a procedure like that, then I'd make sure my name was in a comment at the top, so unthinking copy-and-pasters would preserve the attribution, requiring a conscious decision to deceive if they wanted to delete the author details.

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Nice and easy -- after several days of low correct responses percentages this one is really high.

Original or not, thanks for the question!

Hugo Kornelis SSC Guru Points: 64748 More actions · Answer 6

Toreador (4/26/2012)
some harsh responses IMHO. Who knows whether the author made use of a bit of code from the internet 7 years ago and forgot the source, or maybe one of his co-workers copied it and it's been around on their database for the last few years?

It wasn't just the code of a stored procedure; the original comment was a verbatim copy of the TechRepublic post. Including personal comments such as "Recursion is one of the most elegant programming constructs in my opinion. I have used it in dozens of situations and in several programming languages".

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Toreador SSChampion Points: 11299 More actions · Answer 7

Toreador

SSChampion

Points: 11299

April 26, 2012 at 9:59 am

#1479877

Ah. That's different...

SQLRNNR SSC Guru Points: 281324 More actions · Answer 8

I enjoyed the discussion for this question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Michael Poppers SSCrazy Points: 2148 More actions · Answer 9

Hugo Kornelis (4/26/2012)
I love the "don't know" option, and I agree with the poster above that those who rightfully tick that box should get a point. 😉

Only if they can properly answer the following question:

You flip a coin -- the proper call is

-1- either "heads" or "tails"

-2- neither "heads" nor "tails"

-3- Don't Know

TomThomson SSC Guru Points: 104773 More actions · Answer 10

edit: I see someone already said this. I should have looked on the next page of comments before posting and then I would not have posted.

==============================

Toreador (4/26/2012)
some harsh responses IMHO. Who knows whether the author made use of a bit of code from the internet 7 years ago and forgot the source, or maybe one of his co-workers copied it and it's been around on their database for the last few years?
If I were to post a procedure like that, then I'd make sure my name was in a comment at the top, so unthinking copy-and-pasters would preserve the attribution, requiring a conscious decision to deceive if they wanted to delete the author details.

I shouldn't think anyone cares about the code as such. The text was pretty much a direct copy from the blog entry, too, and that is rather more of an issue.

Tom

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 11

Nice question. I apperently missed something about the explanation.

Ah well... 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

paul s-306273 SSChampion Points: 10666 More actions · Answer 12

Steve Jones - SSC Editor (4/26/2012)
I have rewritten the explanation. Thanks for pointing out the issue.
I have also contacted the author.

Thanks for that Steve.

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 13

I received an apology from the author. I suspect it was a lack of understanding, and plan to let it go.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

zymos SSCommitted Points: 1960 More actions · Answer 14

Interesting topic and good summary on the nested SP.

Thank you.

Iulian -207023 SSCertifiable Points: 7510 More actions · Answer 15

Iulian -207023

SSCertifiable

Points: 7510

May 7, 2012 at 2:58 am

#1484003

Thank for the question

Iulian