• Home
  • About Me
  • Resume
  • Useful Links
  • Português
  • Contact

EmanuelCosta.com

E-Commerce, SEO/SEM/Online Marketing, Web Development, Usability, WordPress & WooCommerce

  • LinkedIn
  • Twitter
Home » Archives for July 2007

Archives for July 2007

I'm on technorati.com

Posted on July 28, 2007 Written by EmanWeb

Technorati Profile

Filed Under: Blogs, Web Development

Apple iPhone – Microsoft Exchange – Impressions – bug?

Posted on July 22, 2007 Written by EmanWeb

Ontem tive oportunidade de ver e usar o “gadget” do momento – iPhone ($500,00 pela ATT). A minha primeira impress

Filed Under: Gadgets

Resposta ao cfgigolo: Sobre CF, Adobe e masculinidade

Posted on July 19, 2007 Written by EmanWeb

Essa abordagem do Alex no cfgigolo, foi muito bem feita e focada para realidade brasileira do CF. Gostaria, muito, mas muito mesmo, de ler uma resposta oficial da Adobe sobre a viabilidade dessas sugest

Filed Under: ColdFusion

Removing duplicated values from a table / Removendo valores duplicados de uma tabela

Posted on July 17, 2007 Written by EmanWeb

In T-SQL you may use “insert” to remove duplicates. What you must do is create another work table with the IGNORE_DUP_KEY option set.

So you copy the data from one table to the other. Drop the original table and rename the work table to your original table name and that's it. You will have a plain, clean, non duplicated records table. Something like:


CREATE TABLE tableCleanDup
(idfield int, field1 varchar(30), field2 varchar(30))
CREATE UNIQUE INDEX removeduplicates ON tableCleanDup (field1,field2) WITH IGNORE_DUP_KEY
GO
INSERT tableCleanDup SELECT * FROM tableOriginal

It will return to you a message “duplicate key was ignored” but that is fine. The tableCleanDup will have the records from tableOriginal but without duplicates.

p.s.: Thanks to Ken Henderson for this T-SQL advice.

Vers

Filed Under: SQL Server and T-SQL

  • 1
  • 2
  • Next Page »

Find Here

About me

Hello, my name is Emanuel Costa. I build professional websites and help companies grow online. I write this blog to help myself about what I learned and perhaps help other people. I help organize meetups and whenever I can I attend tech events, specially WordCamps. Read more about me. (p.s.: Agora escrevo um blog em Português aqui: emanweb.com.br

Latest WordCamp:

WordCamps I Attended:

I am volunteering at WordCamp Las Vegas 2019″ title=

WordCamp Fortaleza

I'm attending WordCamp San Diego

I am Attending WordCamp Miami 2016


WordCamp US

Categories

  • ActionScript
  • Blogs
  • ColdFusion
  • CSS
  • Experience
  • Flex and Flash
  • Gadgets
  • Google
  • JavaScript
  • Linux
  • MySQL
  • PHP
  • SEO
  • SEO and Internet Marketing
  • SQL Server and T-SQL
  • Uncategorized
  • video
  • Web Development
  • WooCommerce
  • wordcamp
  • WordPress
July 2007
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
    Aug »

Recent Comments

  • Peter Crouch on How to output a list of IDs in a field as recordsets / Como retornar uma lista de IDs como recordset
  • Simon on cPanel on AWS EC2 using Amazon Linux w/ Yours Nameservers
  • WordPress Developer? Really? - EmanuelCosta.com on Gracie Brazilian Jiu Jitsu and WordPress. What these two have in common?

Navigation

  • Home
  • About Me
  • Resume
  • Useful Links
  • Português
  • Contact

Need quick tech advice? Pick my brain:

Copyright © 2025 · Focus Pro Theme on Genesis Framework · WordPress · Log in