SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Timestamps


Timestamps

Author
Message
Lokesh Vij
Lokesh Vij
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2046 Visits: 1599
kapil_kk (5/6/2013)
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..Doze

Me too lose the points Sad


+1 Sad

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter


Raghavendra Mudugal
Raghavendra Mudugal
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2958
Good one, thank you for the Kick Start Post. :-)

(well... long story short...) "damn!!!..." (where is my "learn sql in 21 hours for beginners" book?)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Mr. Kapsicum
Mr. Kapsicum
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1159 Visits: 1024
Danny Ocean (5/5/2013)
I think author did mention it clearly that execute all statement in a single batch.
Due to that i lose my points..Doze



Same goes for me as well.... just lost my valuable points Cool
Carlo Romagnano
Carlo Romagnano
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4866 Visits: 3326
The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

+1
:-D
Good qotd, but too long, it worths 4 points.

I run on tuttopodismo
honza.mf
honza.mf
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 1323
Carlo Romagnano (5/6/2013)
The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

+1
:-D
Good qotd, but too long, it worths 4 points.

Hehe
Especially for the majority who answers before first coffee w00t



See, understand, learn, try, use efficient
© Dr.Plch
demonfox
demonfox
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1515 Visits: 1192
I lost patience, the moment I saw "select 8" ...
not a good day to begin with Blink

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm
Hugo Kornelis
Hugo Kornelis
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10868 Visits: 11977
Good question, thanks for submitting, Honza! I agree that it was clear enough that the code was supposed to be run as a single batch.

To the person posting that "select 8" put him/her off - I understand. I had a similar response to seeing the list of answer options (BTW, Kudos to Honza for fighting the QotD submission interface long enough to complete that LOOONNGGG list!). But they were organized wewll enough that it soon was clear that it was simply a matter of responding to eight questions on each of the eight statements.


To the many people complaining they "lost" points - you didn't. You still have as many points as you had before, and by wasting yours and other people's time with your whining, you even earned an extra point. (Can someone please give Steve an entry-level book about raising kids? You know, one that explain you should not reward unwanted behaviour?)

And to the person who even added the word "valuable" before "points" - please tell me exactly how valuable they are to you. I'll gladly sell you mine for 50% of that. Where I work and live, those points are worth exactly nothing, so we would both benefit!


And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please, please, please get rid of that stupid point system. The only effect I see it having is to encourage behaviour that benefits nobody.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
honza.mf
honza.mf
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1931 Visits: 1323
Hugo Kornelis (5/6/2013)
Good question, thanks for submitting, Honza! I agree that it was clear enough that the code was supposed to be run as a single batch.

To the person posting that "select 8" put him/her off - I understand. I had a similar response to seeing the list of answer options (BTW, Kudos to Honza for fighting the QotD submission interface long enough to complete that LOOONNGGG list!). But they were organized wewll enough that it soon was clear that it was simply a matter of responding to eight questions on each of the eight statements.


To the many people complaining they "lost" points - you didn't. You still have as many points as you had before, and by wasting yours and other people's time with your whining, you even earned an extra point. (Can someone please give Steve an entry-level book about raising kids? You know, one that explain you should not reward unwanted behaviour?)

And to the person who even added the word "valuable" before "points" - please tell me exactly how valuable they are to you. I'll gladly sell you mine for 50% of that. Where I work and live, those points are worth exactly nothing, so we would both benefit!


And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please, please, please get rid of that stupid point system. The only effect I see it having is to encourage behaviour that benefits nobody.

Thank you very much.
Writing answers was a hard work but I use a good clipboard tool :-)



See, understand, learn, try, use efficient
© Dr.Plch
Raghavendra Mudugal
Raghavendra Mudugal
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2958
....
And finally, to Steve - I know we've discussed this before, and I know it won't happen, but I just have to ask again. Can you please, please, please get rid of that stupid point system. The only effect I see it having is to encourage behaviour that benefits nobody.


(.... I see the "points" but never kept track of it.. but after reading the above I never realized that people are actually desperate for this; when people mention "lost my point"... i thought they are trying to be funny, metaphorically, not literally. Didn't knew this was serious stuff until now; May be we can change it to SQL CASH POINTS.. like in any next event on SQL, a person who earned more points will get a free-book on SQL with authors sign in it or link to the pdf file to download... :-P Cool )

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8799 Visits: 7279
Good question, thanks Honza
I must learn not to answer before my first coffee!!!!!!!

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search