[thelist] SQL Challenge Question

[Raditha Dissanayake]

Wow, Nice way to bring down your database :-) to do this efficiently you 
need to have an index on each column.  And with that kind of indexing 
your inserts are going to take an eternity, not to mention the disk 
space usage. i know hard disks are pretty cheap nowadays but stil.

Rob Smith wrote:

>Hi,
>
>I've got an SQL Challenge for you.
>
>	Given: Two nearly Identical Rows
>	Problem: Isolate the columns where the data
>		   is not the same.
>	Solution: ?
>
>Can this be done? If so, how?
>
>Rob Smith
>  
>


-- 
Raditha Dissanayake.
------------------------------------------------------------------------
http://www.radinks.com/sftp/          |  http://www.raditha/megaupload/
Lean and mean Secure FTP applet with  |  Mega Upload - PHP file uploader
Graphical User Inteface. Just 150 KB  |  with progress bar.