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 123»»»

Delete Duplicates Expand / Collapse
Author
Message
Posted Monday, May 12, 2008 9:51 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:27 AM
Points: 2,670, Visits: 783
Comments posted to this topic are about the item Delete Duplicates

Jamie
Post #499280
Posted Tuesday, May 13, 2008 12:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:18 AM
Points: 1,205, Visits: 924
Grrrreat question, Excellent answer, 'nuff said:P:P:P:P:P:P

Manie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Post #499334
Posted Tuesday, May 13, 2008 12:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
I'm wrong here but this is not correct question;

1 & 2 are the same ... with same condition! So the correct answer is 2 but the 1 is the same everything ... too stupid!
3 is different!

also with three options I do not have valid parse for T-SQL code!

how can you explain it!?

:P:P:P:P:P


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #499341
Posted Tuesday, May 13, 2008 12:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
OHHH nooooooooooooooooo

I work just from select statement not "with numbered"

pthuuuu

nononononoonononononononono I anaylized very well what happend but without this piece of code!



============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #499343
Posted Tuesday, May 13, 2008 2:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 8, 2013 11:56 AM
Points: 70, Visits: 144
whats happened to sql - it used to be so simple
Post #499379
Posted Tuesday, May 13, 2008 2:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 8, 2013 11:56 AM
Points: 70, Visits: 144
dougi - are you using sql 2000 by any chance?
Post #499380
Posted Tuesday, May 13, 2008 6:21 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, June 7, 2013 6:57 AM
Points: 642, Visits: 200
I agree, this was an excellent question!
Post #499504
Posted Tuesday, May 13, 2008 7:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Thanks for an Excellent question really rather simply once one understands how partitioning works........... learned a lot from it ...


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #499563
Posted Tuesday, May 13, 2008 7:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:46 AM
Points: 2,958, Visits: 755
Gives me more stuff to figure out, thanks for the question.
Post #499578
Posted Tuesday, May 13, 2008 7:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 7:22 AM
Points: 1,187, Visits: 1,984
A semicolon at the beginning of the statement is valid

I'm seeing a lot of this lately. I.e., statements such as:
;WITH ...

Note that the semicolon is NOT part of the WITH statement syntax. This issue only arises if the prior statement did not end with a semicolon (which it should). So the leading semicolon is terminating the prior statement.

SQL Server is starting to enforce proper statement termination. IMO, long overdue. Get into the habit of properly terminating ALL of your T-SQL statements. Even Microsoft recommends using it. From BOL:
Many code examples use a semicolon ( ; ) as a Transact-SQL statement terminator. Although the semicolon is not required, using it is considered a good practice.



(PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.
Post #499592
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse