October 28, 2015 at 8:12 am
:w00t::w00t::w00t::w00t::w00t:
rkaram
October 28, 2015 at 8:13 am
below86 (10/28/2015)
Sean Lange (10/28/2015)
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly you can have some of mine. Last I checked they are still useless.
What? They are useless? I was hoping to trade them in for a free toaster. 🙂
Ohhh did they bring back the toaster? Last time it was for 1,000,000 points. I think Steve and Gail were the only ones to receive a toaster. They gave one to Grant too even though he didn't have enough points. 😀
Oh well, I don't think I can get to a million before Christmas, I'll have to break it to the wife she won't be getting a present this year. 🙂
Or just open a new bank account with $100. May be the best Christmas ever!!! I am off to the bank now to save my own marriage. :hehe:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 28, 2015 at 8:22 am
freyes (10/28/2015)
I tink the question must include the collation, because if the collation is case sensitive the answer will be 2.
I think you mean 3, but yes collation does make a difference. Makes one want to post a question using names in different collation scenarios, how about something like Zoë? I will resist....
...
October 28, 2015 at 8:22 am
Apologies. 5 Rows are returned. The wrong box got checked.
Awarding back points to everyone.
October 28, 2015 at 8:23 am
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly you can have some of mine. Last I checked they are still useless.
What? They are useless? I was hoping to trade them in for a free toaster. 🙂
I got a bottle opener!!
...
October 28, 2015 at 8:25 am
Sean Lange (10/28/2015)
below86 (10/28/2015)
Sean Lange (10/28/2015)
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly you can have some of mine. Last I checked they are still useless.
What? They are useless? I was hoping to trade them in for a free toaster. 🙂
Ohhh did they bring back the toaster? Last time it was for 1,000,000 points. I think Steve and Gail were the only ones to receive a toaster. They gave one to Grant too even though he didn't have enough points. 😀
Oh well, I don't think I can get to a million before Christmas, I'll have to break it to the wife she won't be getting a present this year. 🙂
Or just open a new bank account with $100. May be the best Christmas ever!!! I am off to the bank now to save my own marriage. :hehe:
The problem is I don't think there is one left that would consider me a 'new' account, how do you think I made it through 22 years of marriage. :hehe:
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
October 28, 2015 at 8:28 am
Does that mean I get a toaster now?
October 28, 2015 at 8:31 am
Chris Wooding (10/28/2015)
Does that mean I get a toaster now?
I'm holding out for the SSC T-shirt. 😛
October 28, 2015 at 8:33 am
Ed Wagner (10/28/2015)
Chris Wooding (10/28/2015)
Does that mean I get a toaster now?I'm holding out for the SSC T-shirt. 😛
I know!!! I would wear one. I have a ms-sql tips shirt I picked up at a sql saturday that is just about worn out.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 28, 2015 at 8:36 am
Looks like there's sometimes an advantage to SQL Server Central e-mails getting stuck for hours in our spam filter, it means I missed all this and got given the correct answer for choosing 5... 🙂
October 28, 2015 at 8:47 am
an even correcter answer would be:
It depends
(5 with a case insensitive collation, three if the collation is case sensitive. )
-- Itzik Ben-Gan 2001
October 28, 2015 at 8:49 am
EZ 🙂
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
October 28, 2015 at 9:47 am
Well, I answered 5 because 3 was not an option
as usuall the correct answer is "depends..."
if database is case sensitive then the answer should be 3!
October 28, 2015 at 10:36 am
paul.knibbs (10/28/2015)
Looks like there's sometimes an advantage to SQL Server Central e-mails getting stuck for hours in our spam filter, it means I missed all this and got given the correct answer for choosing 5... 🙂
Similar, except in my case it is -9 hours...
Thanks, Steve!
October 28, 2015 at 10:37 am
Uri.KlilHahoresh 86084 (10/28/2015)
Well, I answered 5 because 3 was not an optionas usuall the correct answer is "depends..."
if database is case sensitive then the answer should be 3!
As has always been the rule with QOTD. Unless otherwise specified assume defaults and the default for case sensitivity is insensitive.
One could always argue the case is "it depends". If you already had that table in your system it would cause an error....unless of course the columns were the same name and datatypes.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 61 through 75 (of 85 total)
You must be logged in to reply to this topic. Login to reply