More wildcard searches

Viewing 15 posts - 46 through 60 (of 85 total)

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

Roshan Oozeer Hall of Fame Points: 3589 More actions · Answer 1

Correct answer is 5 not 4 ... I want my 2 points.... Thank you

Roshan

Toreador SSChampion Points: 11368 More actions · Answer 2

Luis Cazares (10/28/2015)
He's at PASS Summit, so he might not be able to correct this right away.

So how many pages of "the correct answer should be 5" replies will we have by the time he gets back? :w00t:

ekolbasov Newbie Points: 8 More actions · Answer 3

Correct answer is 5 id's will be returned for 5 rows.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank you
Roshan

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.

_______________________________________________________________

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/

below86 SSChampion Points: 11538 More actions · Answer 5

Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank you
Roshan
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. 🙂

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

sestell1 SSChampion Points: 10230 More actions · Answer 6

Has anyone mentioned that the 'correct' answer is wrong yet? :hehe:

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

sestell1 (10/28/2015)
Has anyone mentioned that the 'correct' answer is wrong yet? :hehe:

Just a couple of people have pointed that out so far. Everyone makes mistakes at one point or another.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

cbilik1 Mr or Mrs. 500 Points: 545 More actions · Answer 8

cbilik1

Mr or Mrs. 500

Points: 545

October 28, 2015 at 7:35 am

#1836040

5 rows returned

Y.B. SSChampion Points: 11649 More actions · Answer 9

Oh well, guess I'll just take my point for posting here instead. 😉

SELECT quote FROM brain WHERE original = 1
0 rows returned

pappyd45 SSC Rookie Points: 41 More actions · Answer 10

pappyd45

SSC Rookie

Points: 41

October 28, 2015 at 7:43 am

#1836044

Correct answer should be 5, right?

Rich Mechaber SSChampion Points: 11130 More actions · Answer 11

Ooooooookay, I think we've learned something here: Steve hasn't had his coffee yet today.

😉

Sean Lange SSC Guru Points: 286590 More actions · Answer 12

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 you
Roshan
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. 😀

_______________________________________________________________

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/

rkprince16 SSC Enthusiast Points: 156 More actions · Answer 13

rkprince16

SSC Enthusiast

Points: 156

October 28, 2015 at 7:58 am

#1836053

correct answer is 5

+1

below86 SSChampion Points: 11538 More actions · Answer 14

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 you
Roshan
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. 🙂

-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.

g.maxfield Default port Points: 1471 More actions · Answer 15

Wish I was at th PASS Summit - Always wanted to visit Seattle! :-:alien: