Delete Duplicates

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jamie Longstreet » Delete Duplicates

23 posts, Page 1 of 3

1 2 3 »»»

Delete Duplicates

Rate Topic

Display Mode

Topic Options

Author

Message

Jamie Longstreet-481950

Posted Monday, May 12, 2008 9:51 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:48 AM
Points: 2,440, Visits: 714

Comments posted to this topic are about the item Delete Duplicates

Jamie

Post #499280

Manie Verster

Posted Tuesday, May 13, 2008 12:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:00 AM
Points: 1,151, Visits: 879

Grrrreat question, Excellent answer, 'nuff said:P:P:P:P:P:P

Tongue

Manie Verster
Developer
Johannesburg
South Africa

Life is about choices.... I choose to be happy today

Post #499334

Dugi

Posted Tuesday, May 13, 2008 12:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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!?

Hehe

:P:P:P:P:P

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #499341

Dugi

Posted Tuesday, May 13, 2008 12:43 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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!

Hehe

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #499343

sho-467341

Posted Tuesday, May 13, 2008 2:19 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 11:56 AM
Points: 70, Visits: 144

whats happened to sql - it used to be so simple Wink

Post #499379

sho-467341

Posted Tuesday, May 13, 2008 2:20 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 11:56 AM
Points: 70, Visits: 144

dougi - are you using sql 2000 by any chance?

Post #499380

John Laskey

Posted Tuesday, May 13, 2008 6:21 AM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 6:22 AM
Points: 642, Visits: 199

I agree, this was an excellent question!

Post #499504

bitbucket-25253

Posted Tuesday, May 13, 2008 7:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 5,103, Visits: 20,213

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

Patrick Cahill

Posted Tuesday, May 13, 2008 7:28 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:40 AM
Points: 2,412, Visits: 578

Gives me more stuff to figure out, thanks for the question.

Post #499578

Mauve

Posted Tuesday, May 13, 2008 7:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 10:43 AM
Points: 1,146, Visits: 1,848

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 »

23 posts, Page 1 of 3

1 2 3 »»»

Permissions