I believe INSTEAD OF means just that... if you do not do your Insert/Update/Delete in the Trigger, it does not get done. An Insert/Update/Delete will not...

Not sure exactly what you are after but you can separate it into pieces using Substring and then build a new string with a '-' concatenated between the parts.

declare @oldzip...

Have you tried to increase the Fillfactor for this index?

Toni

This may be way off base (as I sometimes am) but maybe the index is on a View and the settings are not correct?

Toni

From the BOL on Indexed Views:

The CREATE...

Here's a way to do it with a single select and without a cursor or a temporary table.

Insert into TableFinal

select coalesce(t1.memberid,t2.memberid,t3.memberid) 'memberid', initialjob, intermediatejob, lastjob

from @t1 t1

full outer join...

Sergiy. Your post was quite interesting.

I tried unsuccessfully to look up under what conditions a Raiserror would cause the trigger to cancel the Insert or...

Agree that it is best to not use a cursor at all; however, if you use a GLOBAL cursor, you can pass it between procedures. The Global cursor...

Here are some cleaner versions of the triggers that would handle multiple rows in an Insert/Update. I had to add an Identity column (unless you have a unique...

If you need to determine what to do based on the value of a particular row against that of another row in the same table, a Trigger is your only...

First I will admit to not fully understanding your question; however if you mean a table in both DBs can be updated at the same time (bi-directional) then you would...

Try having the Workgroup server join the domain of your target server.

Union all is a clear winner..

If you do a UNION ALL you will get all the rows and take less resources as there is no need to sort out the...

If the parameter columns do not allow nulls then you can do the select using Coalesce. With the key part being the Where clause...

where region = Coalesce(@region,region) ...

Treading lightly in the company of so many gurus....

have you considered doing a BulkInsert and/or checking to see what the FillFactors are? If files are...

Agreed Chirag, you would not use the '*' (did not mean to imply you would - just lazy on my part to leave it in).

shwetha004 had stated...