That should work.

The update audits are pretty standard. I don't use them, because any place I need to audit that, I need to know more than when it was...

Are you looking for that last time data in the table was changed, or the last time the table structure was changed (added a column, for example)?

Bruce W Cassidy (3/24/2009)

---

[font="Verdana"]There are 10 kinds of people in the world: those who understand...

Bob Hovious (3/24/2009)

---

I did, back in the early 80s, when computers were still hand-cranked. People didn't trust me when I started counting from...

You'll need to expand and translated this to work with your actual tables and actual results, but here's something that will test them.

-- Create test tables

create table #A (

ProductID int...

Do you have a Numbers or Tally table? If so, then yes, it's quite easy to split without a loop. Actually, it's faster than it would be with...

lmu92 (3/24/2009)

---

We have a saying over here in...

On something this complex, I would move each set of updates to it's own proc, and create one proc that calls each of those in turn. Try that, see...

You might want to look into SSRS 2008. It has some significant improvements over 2005.

I've had some problems getting earlier versions of SQL Server to connect to later ones....

I'm going to recommend taking a look at Full Text Indexing. Check it out, it will almost certainly do what you want, better than "like" statements will. Has...

I prefer to keep such in the database, in procs. That way, if a table needs to change, it's much easier to find all procs that depend on the...

RBarryYoung (3/24/2009)

---

GilaMonster (3/24/2009)

---

RBarryYoung (3/24/2009)

---

It's like the old joke:

Q: How many psychiatrists does it take to change a light bulb?

A: Only one. But it takes a very long time and...

Your query is using "nodes()" on "productRef", but there's only one productRef in your XML sample.

I've attached a query that will get the second result you want. The main...

foxjazz (3/24/2009)

---

GSquared (3/24/2009)

---

Use this:

declare @ID int;

--

select @ID = productcontrolid

from productcontrol

where productcontrolid in

(select top 25 productcontrolid

from productcontrol

order by productcontrolid desc);

That'll get you an ID you can use for your update.

Then just...

I tried creating a test table with a constraint that looks like it should restrict the hierarchy to one level, but I must be doing something wrong.

Here's the test table:

if...