Search results for query: *

I'm a little confused. You original post stated, "I need to know any new phone numbers that are added to the phone book database. That way I can add the name and address." If you are going to "add the name and address", you are changing something. It appears you can not...

Until Microsoft adds an aggregate string concat function; or, you write your own extended function, the only solution I am aware of is to use a cursor. DECLARE @CustID int, @CallID int, @NotesAll varchar(3000) DECLARE ncur CURSOR FOR SELECT DISTINCT T1.CustID, T1.CallID FROM...

Assuming each new phone number is entered minus its address, write your SELECT as "WHERE Address is NULL". If the address is unknown can you enter "N/A" or anything else, e.g. a space, to make the Address no longer NULL. At the worst make your "NOT EXISTS IN...