Thanks for your help.

However, I have seen the "For Each" loop and followed a tutorial using one. But, I guess what I'm really asking is how should I group SSIS...

Perfect! Thanks 🙂

Mike01 (4/25/2012)

---

I guess my question would be why are you doing this in a trigger. If you're worried about the number of records you are inserting or updating, why...

Bingo!! 🙂

I knew there had to be a slicker way of achieving what I want.

Many thanks for the excellent tip! 🙂

Thank you for the excellent advice.

I am especially pleased with your CTE-based technique as an alternative to my DELETE statement as originally posted. This is precisely the sort of...

i

After making the changes as per your revisions to the trigger, the results are in!

The original run with the old trigger code took 1 hour...

Of course ...

Here's the trigger code :

USE [SampleDB]

GO

/****** Object: Trigger [dbo].[TRG_Log_TempSales2_Changes] Script Date: 03/01/2012 11:17:55 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/**********************************************************************

* Function :...

Thanks once again John.

Thanks for the recommendation John.

I did geet the same product suggested to me by another member here and although I haven't yet downloaded it, it looks promising.

I suppose the...

BarneyL (2/16/2012)

---

In that case getting IIS running on your machine and then making use of something like the latest Adobe Dreamweaver trial to build some web pages could be the...

Thanks for the info, but I'd realy rather avoid having to use something like Excel. I was thinking more of a browser-based solution if possible.

BarneyL (2/16/2012)

---

One quick and easy front end you might have use of is MS Access, you can link SQL Server tables in to it and then build forms in Access...

GilaMonster (2/8/2012)

---

That's a client error. You've run your client machine out of memory.

It's not a SQL Server error (and so unrelated to caching of data pages on the server) because...

klowman (2/7/2012)

---

I had the same issue, and was able to fix it by going to the Tools menu, select Options and when the Dialog box appears, expand the SQL Server...

John Mitchell-245523 (2/7/2012)

---

An index enforcing a primary key constraint will indeed be created clustered by default, but if there is already a clustered index on the table, the new index...