Great. You may also want to consider adding an index on the location column to prevent table scans.

This is not returning results because your IN and your LIKE conditions conflict with each other. It looks to me, without seeing sample data, that you just need to...

1) Theres probably more reasons why you wouldn't want it to work this way than there are for working this way. Here are a few....

-- Dependancy checking in SPs...

Never had one.....heard they're fantastic.

ChrisM@home (11/20/2010)

---

Manchili.

Meat and chillies, no beans.

Onions, garlic, whole cumin seeds browned with the meat. Red chillies for colour, green for flavour. Cumin powder with the crushed tomatoes. Rich stock...

Rob Schripsema (11/18/2010)

---

John Rowan (11/18/2010)

---

...

I'm sure there are more pros/cons that I listed here in a quick minutes, but that's the main area I can think of. Todd's method...

Rob,

The method you've described will not allow for multi-threading the process. You will not be able to achieve multi-threading from within one package as you've described because the...

Good job Wayne....you beat me to it. I know a cte could do the trick, I was just working through the update logic.

Great solution!

That would be great if I had a SS2008 instance to run it on. This fails on SS2005....

What's with the binary dates?

First thing is that you are missing 2 arguements in your NULL(DT_STR) element. The format for this should be NULL(DT_STR, <<Length>>, <<Code Page>>).

Second. What is the...

In addition to what Joe has posted, please refer to the article in my signature line for assistance on creating a post with proper examples and sample data. Following...

A simple GROUP BY will do the trick....

DECLARE @Table TABLE (Inventory int, Product varchar(10))

INSERT INTO @Table

SELECT 12345, 'ABC' UNION ALL

SELECT 12346, 'ABC' UNION ALL

SELECT 12347, 'ABC' UNION ALL

SELECT 12348, 'ABC'...

1. The only way you'll be able to make a generic script that can work for any table is to use dynamic SQL. Here's a good reference for...

diamond