Thanks for the reply.

I went with a simpleir query

update master_sub

set [lab count] = o_list.[lab count],

= o_list.

from master_sub m, o_list o

where m.id = o.id

THANK!! WORKED PERFECT!!

have a great holiday

I tried a few different queries.

This one has the format I need but does not address the Adds and deletes.

SELECT o. Id,

CASE WHEN o.Application=n.Application

...

I tried a few different queries.

This one has the format I need but does not address the Adds and deletes.

SELECT o. Id,

CASE WHEN o.Application=n.Application

...

THANKS A MILLION!! works perfect.

another question, what does <> mean?

No, same error.

Yes, i know there is a login trigger i created it. the problem is i dropped a database "AuditDatabase" before i deleted the trigger now i am unable to logon...

C:>sqlcmd -S CRPHSQL -E -A

HResult 0xFFFFFFFF, Level 16, State 1

SQL Server Network Interfaces: An error occurred while obtaining the DAC port. Make sure the SQL Browser is running, or check...