I'm with Lowell on this one. The few times I've come across aggregates maintained by triggers, they were flaky and I replaced them with aggregate views, which performed well...

breakwater,

Is there something you didn't get about using a UNION ALL query? I'd be happy to explain.

Your original post doesn't really have the full query and it's very difficult...

It looks like you are trying to concatenate the 3rd column based on the first 2 columns. If so, here is an excellent article on concatenating columns (turning rows...

For something like this you are probably better off doing 2 mutually exclusive queries and a UNION between them.

In the first one do something like:

-- OR the bits. This...

Jason,

I can't make out from your posted query any sort of relationships between the 3 tables. The way you posted the queries, they look like a CROSS JOIN of...

DucatiRider (12/7/2011)

---

Hi, thanks for the notes; much appreciated! I don't know why the READ Uncommited was added. I inherited the maintenance of these stored procs from someone else....

Bubs,

Your best bet in this is to create an actual calendar table. Search calendar table on the forum and you'll come up with some articles I wrote and some...

Please post a script to create the table, some test data and the expected results. I can't figure out what you want based on what you posted.

Todd Fifield

Glad to help.

Todd Fifield

Jason,

Is there a business reason for this?

Todd Fifield

Kyle,

The trigger as it stands won't do anything for an INSERT since the inserted table won't join to the deleted table. The IF UPDATE(STK_COSTPRICE) will always test true for...

You will probably find that <> is just a little bit easier for others to understand since it is more common.

Todd Fifield

Ninja's_RGR'us (12/2/2011)

---

>>>>>

Ninja's_RGR'us (11/30/2011)

---

Well actually in your case it would be to clean the select in the first place. Deduplication has many forms and purpuses so I can't give you...

Remi,

What I meant was that WHERE NOT EXISTS () prevents an insert based on what's in the SELECT list already existing in the destination...

Grant,

Feel free to promote that product any time. Like Gail, it's saved my bacon when everyone is breathing down my neck to fix some procedure that was basically unreadable...