Posted by Erland Sommarskog on 09/20/06 21:27

SQLNewbie (tahnee.puckett@bancsourceinc.com) writes:
> I have the following cursor that I am comparing 2 tables, the
> production table and a copy of the production table, I want results of
> all address's that are like the address1 field...the problem is...my
> results are giving me every field and if there is more than one, it is
> putting it in a grid....
>
> I only want to see results if they are > 1 for the same address field

If it's a copy, isn't it the same data then?

I was trying to understand what you really want to do, but I'm afraid I
don't.

I would suggest that you post:

o CREATE TABLE statements for your tables, preferably to show the
pertinent points.
o INSERT statements with sample data.
o The desired output given the sample.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Question on System and Data Restore
• Prev in forum: Re: cursor to compare/report on the same fields in 2 tables
• Thread view: Re: cursor to compare/report on the same fields in 2 tables

[Reply to this message]