What's the size of the columns that you ommitted in the 2nd select?

Is this a production server?

Are you testing directly from the server's pc (so that the network is not a factor)?

Are you sure you have 2 different views (doesn't show on...

Check both execution plan. The answer is most likely there. Maybe you move from an index scan + bookmark lookup to a clustered index scan somewhere and that...

HTH.

In case you meant the owner of the db >>

select name, suser_sname(sid) as owner, convert(nvarchar(11), crdate) as CrDate from master.dbo.sysdatabases

Select name, user_name(uid) as Owner from dbo.SysObjects order by name

You need to have a case statement per column >>

, case when Payday is not null then AltValue else 0 end as totPaid

, case when WRcurrentStatus = 110 then AltValue...

Send the new records to a staging table. Then insert the new records that are not duplicates.

Nice to hear that. I'll try to remember it .

Are you sure??

AFTER INSERT

AS

Can you show me your current statement and the expected results vs the current results?

One more reason to not use sp in triggers .

Simple trick >> Where BitColum = CAST(0 AS BIT)

but they usually make poor index because of selectivity .

Why's that??

Select O.Name, MAX(I.rowcnt) AS rowcnt from dbo.SysObjects O inner join dbo.SysIndexes I on O.id = I.id where I.indid = 100 order by O.name

Please note that this is an approximate row...