Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

TOP clause WITH TIES Expand / Collapse
Author
Message
Posted Thursday, May 30, 2013 7:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:06 AM
Points: 1,244, Visits: 1,592
L' Eomot Inversé (5/30/2013)
That's a fun question.

But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial reasoning).


I hope not. Knowledge in itself does not a database professional make. You can know the entirety of BOL (plus the necessary corrections) but if you aren't able to reason out a situation to identify which knowledge to apply and how to apply it, you'll be a crappy DBA/developer.
Post #1458214
Posted Thursday, May 30, 2013 7:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
L' Eomot Inversé (5/30/2013)
That's a fun question.

But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial reasoning).


I second Tom. Qotd should have mix of knowledge + reasoning test!


~ 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

Post #1458232
Posted Thursday, May 30, 2013 8:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:29 AM
Points: 1,191, Visits: 2,022
Great question!
I did spot the difference in the two columns, but messed up the logic when answering.
Post #1458247
Posted Thursday, May 30, 2013 8:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 16, 2013 11:37 AM
Points: 97, Visits: 309
Great question. Definitely need some more logic questions on QOTD.
Post #1458265
Posted Thursday, May 30, 2013 5:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 29, 2013 7:03 PM
Points: 197, Visits: 457
L' Eomot Inversé (5/30/2013)
That's a fun question.

But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial reasoning).

A mix of both, dressed up with some gratuitous misdirection, is what makes it fun for me. It is also a better reflection of many real world situations that way.
Post #1458498
Posted Thursday, May 30, 2013 11:41 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:54 AM
Points: 648, Visits: 134
I messed with the question... But like your No cheating comment....
Post #1458523
Posted Saturday, June 01, 2013 5:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 21, 2013 12:32 AM
Points: 2,556, Visits: 2,593
Thanks Ron for the QoTD. Today, I've learned that "TOP WITH TIES" returns ties only iff the last row is tied. Darn, all along, I was thinking TIES works on all rows.

Its too bad, I have to go back and check all the hundreds of procedures. But I think it should not function like it, rather it should work on all tied rows.


--Ramesh

Post #1458935
Posted Thursday, June 13, 2013 10:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 20,455, Visits: 14,076
interesting question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1463209
Posted Monday, June 17, 2013 12:52 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:04 AM
Points: 3,517, Visits: 2,606
Good one.
Post #1464003
Posted Wednesday, June 26, 2013 10:27 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 11:09 AM
Points: 583, Visits: 962
Nice one

Pramod
SQL Server DBA | MCSA SQL Server 2012
Post #1467951
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse