|
|
Posted by David Portas on 09/20/06 20:26
SQLNewbie wrote:
> 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
>
> this is what I have so far....
>
[snip]
You refer to yourself as a "newbie". If you are new to SQL or to SQL
Server then do not even attempt to write cursors.
There are nearly always better alternatives to cursors. It's only when
you have a lot of experience that you can make an informed decision
about when a cursor makes sense. Meantime, if you can't think of
another way to do something it would be better to ask for help rather
than try to write a cursor. You'll learn good practices a LOT quicker
that way.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|