SELECT options

Question

SELECT options

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

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

Ken SSCoach Points: 17191 More actions · Answer 1

Nice question. I have actually used with ties once in a reporting query. Glad to see a question about a rarely used piece of syntax.

Kangana Beri SSCrazy Points: 2184 More actions · Answer 2

Kangana Beri

SSCrazy

Points: 2184

April 13, 2012 at 4:59 pm

#1473585

Good question, learned something new. Thanks!

Kameswari Aravindh SSCrazy Points: 2380 More actions · Answer 3

Nice Question. Got to learn something new today. Thanks. :-D:-)

Chris Umbaugh Ten Centuries Points: 1334 More actions · Answer 4

Did not know about WITH Ties. Great question!

Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 5

Thanks for TIES

IgorMi

Igor Micev,My blog: www.igormicev.com

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

Good question, liked it. Never used WITH TIES but glad to know I remembered how it worked 🙂

Some familiar names on the list!

EL Jerry SSCertifiable Points: 7063 More actions · Answer 7

Gazareth (4/18/2012)
Good question, liked it. Never used WITH TIES but glad to know I remembered how it worked 🙂

I'm glad you liked it too. I stumbled upon WITH TIES accidentally and thought it would be worth giving it a try.

Some familiar names on the list!

I was trying to build up some names, but found it easier to take some names from the community. Obviously, I had to be the "best seller" :-D.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Enigma475 Ten Centuries Points: 1247 More actions · Answer 8

Great question, thanks! I didn't know about any "variations" of the top statement. Learned something new today.

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 9

very new question, learn something new .

Thx 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 10

Good straightforward question. Thanks for submitting.

http://brittcluff.blogspot.com/

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 11

Hardy21

SSCrazy Eights

Points: 9708

May 30, 2012 at 3:30 am

#1494520

Nice question. Learn something new...

Thanks

WayneS SSC Guru Points: 95460 More actions · Answer 12

Good question, thanks! It's always nice to brush up on things.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

EL Jerry SSCertifiable Points: 7063 More actions · Answer 13

WayneS (7/1/2012)
Good question, thanks! It's always nice to brush up on things.

Thank you, Wayne. Glad you liked it.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

BudaCli Hall of Fame Points: 3404 More actions · Answer 14

Koen Verbeeck (4/12/2012)
Very very nice question (not only because my name is in it :-D)
Never used WITH TIES before, so I definately learned something.
Good question to close the week.

same here. And i hardly ever used % as well

What you don't know won't hurt you but what you know will make you plan to know better

EL Jerry SSCertifiable Points: 7063 More actions · Answer 15

BudaCli (8/2/2012)
Koen Verbeeck (4/12/2012)
Very very nice question (not only because my name is in it :-D)
Never used WITH TIES before, so I definately learned something.
Good question to close the week.
same here. And i hardly ever used % as well

Thank you, BudaCli. Glad you liked it.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]