Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: Removing Duplicate Records

    And ofcourse you can create a CHECKSUM computed column which is calculated from all other fields. So you can determine all the duplicate records easily, they are all give the...

    April 21, 2008 at 1:20 am

    #804775

  • RE: Removing Duplicate Records

    I'm using that method (creating a unique index) for already existing tables. I mean without changing the original table.

    If you able to change / redesign your table you can add...

    April 18, 2008 at 8:30 am

    #804400

  • RE: Removing Duplicate Records

    ted.pin (4/18/2008)

    If the data set is large, and there are no FKs defined on the table, a faster method might be to SELECT INTO a physical table (which will create...

    April 18, 2008 at 7:39 am

    #804336

  • RE: Removing Duplicate Records

    DAvid (4/18/2008)

    Are you sure you don't mean

    INSERT INTO phonebook SELECT

    [phonenumber],

    [firstname] ,

    [lastname] ,

    [company]

    FROM #tmp

    DROP TABLE #Tmp

    at the end

    Sure. I fixed the artice now.

    Thank you.

    April 18, 2008 at 7:37 am

    #804335

  • RE: Finding most recently inserted record

    God! What did I think when writting this query! 🙂

    Anyway, why Query Analyzer gives that results for these queries?

    46% : select * from myTable where id = (select max(id) from...

    March 27, 2008 at 10:01 am

    #794704

  • RE: ON or WHERE in JOINS

    I understood your point, you're completly right, thanks a lot.

    February 28, 2008 at 3:06 am

    #783065

  • RE: ON or WHERE in JOINS

    I see the first one, but why the second query works as a INNER JOIN? I use a LEFT JOIN.

    As I know (I'm not an expert btw) the difference is...

    February 27, 2008 at 8:34 am

    #782561

Viewing 7 posts - 16 through 22 (of 22 total)