slingblade
Last Activity: Sep 29 '11, 02:09 PM
Joined: Sep 28 '11
Location:
-
The duplicate records ALWAYS have the same name, the same street address, but different monthly amounts. The monthly amount on the dupe record is always zero, no exception.
There could be other zero monthly amounts, but there wouldn't be duplicate name/address records for those, as shown by ID record 9 in my example table. So I can't just say, "select * from site where monthly <> 0". I have to have some kind of name...Leave a comment:
-
Help with SQL script
There must be a way to do what I want to do without using a cursor, but I can't think of it. FYI, I'm a marketing analyst and not all that good with sql.
Here's the scenario:
SITE table
...Code:ID NAME AD1 CITY STATE MONTHLY 1 JOHN DOE 11 MAIN ST BIGCITY FL 30.00 2 JANE DOE 22 MAIN ST BIGCITY FL 25.00 3 BOB SMITH 33
No activity results to display
Leave a comment: