Okay after reading your posts and some articles on normalization, I'm considering doing it this way.

Let me ask this...

I have a tbl_Software and tbl_Computers. tbl_Software would look something like...

edit: On Point #2, I think you may have misunderstood how I have it set up. No matter how many applications get loaded on machines, I'll never have...

It works perfectly. It's now part of the DTS package I'm using to import the data.

Thanks again, this would have taken me forever to figure out otherwise, and my...

Thanks for the advice, Ian.

I did actually think about doing it that way when I planned out the db structure, but decided against it mainly for two reasons:

1) It...

Ah, I see what you're saying.

Thanks for all your help guys, I've got this working now, and added it as a step in my DTS package that is handling all...

Thanks for the reply rbarryyoung, giving it a shot now.

John Rowan (3/27/2008)

---

From the looks of your code, you are trying to do this procedurally, maybe even with a cursor...correct?? This whole operation can be done with 2 set...

By the way, this is the closest I've gotten on my latest fumbling attempt at this:

SELECT dts_SWInventoryTemp.ComputerName FROM dts_SWInventoryTemp

WHILE EXISTS (SELECT dts_SWInventoryTemp.ComputerName FROM dts_SWInventoryTemp)

BEGIN

IF EXISTS

...