Update or Insert from one table to another

Question

Post reply

Update or Insert from one table to another

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

aaharris SSC Veteran Points: 215 More actions · Answer 1

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 this:

SWID Title Publisher Licensed

------------------------------------------------

001 Photoshop Adobe Yes

002 ActivePerl ActiveState No

What would be the best way to link tbl_Computersto that?

Something like this doesn't really seem like a good solution:

ComuterName Uptime DatVersion Software

1IAN3OAL3 11D 4H 03/25/2008 001; 002; 004

0ENAC8EN 4D 9H 03/25/2008 003; 004; 006

Short of coming up with some sort of hex bitmask, am I missing something fundamental here?

mrpolecat SSCertifiable Points: 7014 More actions · Answer 2

You would have a table that contains the computerid and the softwareid with a record for every piece of software that is installed on each computer. You would then link this to your computer table and your software definition table.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 3

mrpolecat (3/28/2008)
You would have a table that contains the computerid and the softwareid with a record for every piece of software that is installed on each computer. You would then link this to your computer table and your software definition table.

Agreed.

That way - your "display screen" would then have a main area for the computer info, and a scrollable area (say - gridview in ASP.NET for example) for the software. It them becomes child play to hide or display more packages as you decide to - - just change on place (the query), and poof - more software shows up. No change to the UI.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?