Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Design database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-14 : 07:00:58
Akram writes "Dear Sir/Madam
I have a big problem for getting correct results (report)from my database. ofcourse my application is completed about 80%. but now when I want to make my reports I found that my database design is not correct (return duplicate records).
I want to save all information about hardware in an office (like ram, hard, Monitor,...)and then in my application select all hardware that one computer need. So in this way I can save all information about each computer and I know how many free hardware exsit.
My database is consist of one table as Master (Id,comuter name,computer User, ...) and one table for each hardware as Detail that all of them consist "Id" that is in Master table.

thanks a lot

Sql server vesion 7.0
Windows Xp with service pack 2.0"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-14 : 14:39:40
What is your question?

Tara
Go to Top of Page
   

- Advertisement -