Posted by Hugo Kornelis on 03/02/06 01:20

On 1 Mar 2006 03:04:35 -0800, vvyshak@gmail.com wrote:

>Hi all..
>I have two tables such as cisco and ciscocom. and i wan to compare each
>row of ciscocom with cisco having same column values. i wan to get the
>count of matching columns for each row in cisco...
>eg:
>Ciscocom has columns: Products,fw,ports,sec,des,tput etc and cisco has
>columns:fw,ports,sec,des,tput etc. i wan the number of matching colum
>for each row in ciscocom. please provide me with the procedure....
>Waiting for your response....

Hi Kuttan,

I just answered this question in microsoft.public.sqlserver.programming.
Please don't post seperate copies of the same question to several
groups!

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Can I do this in SQL Analyzer or with a dts package?
• Prev in forum: Re: Convert Sting to Date
• Thread view: Re: getting the matching columns from two tables

[Reply to this message]